Project - Forecasting or Spreadsheet Modeling

Assignment Help Applied Statistics
Reference no: EM131844815

Mini-Project -

To give you practical experience in implementing the quantitative methods taught in this course and to help you see how you can successfully improve business processes using Statistical Thinking, the principle assignments of the class are mini-projects of your own choosing.  I wanted it to be this way so that the course would be meaningful to you since you are going to try to improve something that is important to you and not simply work on a case study or word problem assigned by me.  This is authentic assessment.

There are four such mini-projects:

1. Mini-Project 1: Descriptive Statistics and Data Visualization.

2. Mini-Project 2: Forecasting or Spreadsheet Modeling

3. Mini-Project 3: Modeling and Design of Experiments.

4. Mini-Project 4: Statistical Inference.

Choosing the right project, the right process to study, is half the battle!  Each of the four projects you choose should have these three qualities:

1. Involve a process about which you know something so that you can apply subject matter knowledge. The importance of this cannot be overstated.

2. Allow collection of sufficient relevant data.

3. Provide an opportunity for intervention and improvement.

Recall that the objectives of the course are for students to be able to:

1. Design data collection plans

2. Collect and organize data using Microsoft Excel

3. Analyze that data using Microsoft Excel

4. Arrive at "right answers"

5. Convert "right answers" into business decisions

6. Present their findings persuasively using appropriate data visualization tools and language

In your second project, you will obtain data from some process in your life that can be forecast using the tools of time-series analysis. You will then use the various forecasting methods available to you to "predict the future". You will choose the method that yields the lowest mean absolute deviation (MAD) or mean squared error (MSE) and describe your thought processes as you do so.

Have the little PowerPoint explanation separately.

Reference no: EM131844815

Questions Cloud

Homeless people to engage in society : Could you please come up with some effective ways to help homeless people to engage in society?
What are the principles in tension : Analyze a current ethical issue in the nonprofit sector using the analytical framework for ethics discussed in class and Independent Sector principles.
Characteristics of cultures can help us better adapt : Knowing characteristics of cultures can help us better adapt, understand, and prevent problems when communicating with other people of different cultural
Foundation of successful relationships : How is good communication the foundation of successful relationships, both personal and professional?
Project - Forecasting or Spreadsheet Modeling : Project - Forecasting or Spreadsheet Modeling. Recall that the objectives of the course are for students to be able to: Design data collection plans
Calculate the proportion of people in centervale : Calculate the proportion of people in Centervale who are exposed to well water (i.e., water from the aquifer) and Metropolis water. Show your work.
Discuss configuration steps needed to install and configure : Discuss the configuration steps needed to install and configure a highly available DNS and DHCP landscape.
Effectively communicating or receiving a message : Next, share an experience in which your perception of self or others interfered with effectively communicating or receiving a message.
How locks could be used in order to qualify data transaction : Describe how locks could be used in order to qualify data transactions and enhance concurrency control. Suggest two business scenarios that would benefit.

Reviews

Write a Review

Applied Statistics Questions & Answers

  Find a peer-reviewed journal article

Find a peer-reviewed journal article that employs the Pearson's correlation coefficient

  What are the mean and variance of x

Among 10 people, 2 people have a pulse of 50, 3 have a pulse of 70, 4 have a pulse of 80, and 1 has a pulse of 90.  If X = the pulse of 1 person picked at random from the 10, what are the mean and variance of X? (Make a probability distribution table..

  Calculate the process capability

Calculate the process capability (Cp and Cpk) for each hole and explain your results.  Estimate what sources of variation may or may not exist in order to make it in control

  Calculate the residuals for the model

Finding and plotting residuals. Consider the data on x and y shown in the table.- Fit the model E(y) = β0 + β1x to the data.- Calculate the residuals for the model.

  Graphically depict a decision making situation

Decision trees are used to graphically depict a decision making situation. Propose a business decision in which you intend to use Expected Monetary Value (EMV) as your decision making technique. Describe how you would determine the best decision usin..

  Identify the data collection methods used in that research

Identify the data collection methods used in that research and analyze that data, evaluate its validity, and then draw conclusions from it in the form of a summary.

  A randon sample of monthly gasoline bills for a company''

A randon sample of monthly gasoline bills for a company's 15 sales persons are:$216-254-247-257-231-265-221-226-228-252-235-265-272-285-266. what is the mean? what is the median? what is the value of quartile 3? what is the value of the mode? the ran..

  The percentages of satisfactory articles

It has been found from past experience that of the articles produced by a factory, 20% come from machine 1, 30% come from machine 2 and 50% come from machine 3. The percentages of satisfactory articles among those produced are 95% for machine 1, 85% ..

  A company that makes traffic signal lights buys switches

1)A company that makes traffic signal lights buys switches from a supplier. Out of each shipment of 1000 switches, the company will take a random sample of 10 switches. The company has a policy of rejecting a lot if they find any defective switches i..

  Develop an estimated regression equation

Develop an estimated regression equation that can be used to predict WinPct.what are the most important factors affecting percentage games won?

  Jane wants to setup a photo shop the cost to rent an office

jane wants to setup a photo shop. the cost to rent an office is 150 per week. the variable cost of making one photo is

  What can not represent the probabilty of a event

What can not represent the probabilty of a event0, .008, - -.6,  55%   605/1269,  50/37 choose answer below

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd