Forecasting or spreadsheet modeling

Assignment Help Applied Statistics
Reference no: EM131842785

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. 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.

Reference no: EM131842785

Questions Cloud

What would be the important financial statements to be : As a potential partner, what would be the important financial statements to be in place for an initial assessment of the venture?
Explain how kant theory helped him to overcome : Explain how Kant's theory helped him to overcome Hume's skepticism and allows us to have empirical knowledge. Please provide the authentic solution.
Determine how training can address the issue : Throughout this course, a great deal of information has been discussed regarding the importance of training and development as related to employee recruitment.
What is one philosophically interesting element of buddhism : What is one philosophically interesting element of Buddhism? Perhaps an insight into people or a commentary on reality that resonates with you?
Forecasting or spreadsheet modeling : 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
Determine the best set of order quantities : Discuss where heuristic decision making might be better than using Optimization. What are the benefits v costs?
Consider the demise of bitcoin : ?Why does Lovink consider the demise of Bitcoin (the digital currency) inevitable? Do you agree with Lovink's assessment that Bitcoin (the technology)
Briefly review and discuss the targeted product : Identify where the major transportation modes are used in the EESC from SLP3: rail, inland water, ocean steamer, and/or OTR.
Describe the epistemological relativism : 1. Describe the epistemological relativism from Plato's day and our day (postmodernism).

Reviews

Write a Review

Applied Statistics Questions & Answers

  A candidate for the key pair

The cryptanalyst computes y = Dx' (c0), where D is the decipherment function corresponding to E, for each possible key x', and then checks the table to see if y is in it. If so, (x, x') is a candidate for the key pair. How should the table be ..

  What p-value did you get in your randomization

What p-value did you get in your randomization and explain in the context of the problem what the p-value means. What is the variable of interest and what graphical techniques will you use to describe your data?

  Construct a stem and leaf diagram with the last digit

Construct a stem and leaf diagram with the last digit being a leaf and the first digit a stem. Repeat stem values twice.

  The last passenger ends up on his own seat

The last passenger ends up on his own seat?

  Qgramming -- product outputnbspnbsp

q1 linear programming -- product outputnbspnbsp nbspa company produces 3 different products a b and c.

  What is a typical score for this sample

Testing of 20 randomly selected subjects yielded two sets of scores: Verbal IQ and Reading Comprehension. The table below displays the results and descriptive statistics, as well as frequency distribution charts for each variable and a scatterplot..

  What does difference between the two population means

What does the confidence interval suggest about the difference between the two population means? Based on this result, does it seem that obsessive-compulsive disorders have a biological basis?

  The national institute of mental health published an article

The National Institute of Mental Health published an article stating that in any one-year period, approximately 9.5 percent of American adults suffer from depression or a depressive illness. Suppose that in a survey of 100 people in a certain town, s..

  Calculate the sample size needed given these factors

Calculate the sample size needed given these factors

  General population form a normal distribution with a µ

IQ scores from the general population form a normal distribution with a μ = 100 and σ = 15. However, data indicate that children's intelligence may be affected if their mothers have German measles during pregnancy.

  Standard normal distribution

Standard normal distribution: finding the probability that a randomly selected cell phone bill is between 60 and $83?

  Find reasonable estimate of minimum cost of correcting error

If it costs the company $10 to correct an erroneous travel voucher, find a reasonable estimate of the minimum cost of correcting all of last month's erroneous travel vouchers.

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