Exercise
1. Graph three plots Sales, Forecast, center moving average | ||||
2. Predict the sales in year 5 for each quarter using forecasting | ||||
Quarter Data for Car Sales | ||||
Year | Quarter | Sales (1000's) | Moving average (4) | Center moving average (baseline) |
year 1 | 1 | 4.8 | ||
2 | 4.1 | |||
3 | 6 | |||
4 | 6.5 | |||
Year 2 | 1 | 5.8 | ||
2 | 5.2 | |||
3 | 6.8 | |||
4 | 7.4 | |||
Year 3 | 1 | 6 | ||
2 | 5.6 | |||
3 | 7.5 | |||
4 | 7.8 | |||
Year 4 | 1 | 6.3 | ||
2 | 5.9 | |||
3 | 8 | |||
4 | 8.4 |
Exercise 1. Graph three plots Sales, Forecast, center moving average 2. Predict the sales in year...
1. Graph three plots Sales, Forecast, center moving average 2. Predict the sales in year 5 for each quarter using forecasting Quarter Data for Car Sales |Sales (1000%) 4.8 4.1 |Quarter Center moving average (baseline) Moving average (4) Year year 11 6.5 5.8 5.2 6.8 7.4 Year 21 Year 3 5.6 7.5 7.8 6.3 5.9 Year 4 1 8.4 1. Fill out the two column (Moving average 4 cells) 2. and the center moving average Quarter Data for Car Sales...
You can click to download the file attached activity 4 Graph three plots.docx 1. Fill out the two column (Moving average 4 cells) 2. and the center moving average Quarter Data for Car Sales Moving average Center moving average Sales Quarter (1000s) 4.8 4.1 Year (baseline year 11 6.5 5.8 5.2 6.8 7.4 4 Year 2 1 3 4 Year 3 5.6 7.5 7.8 6.3 5.9 Year 4 4 8.4 Attach File You can click to download the file attached...
1. Fill out the two column (Moving average 4 cells) 2. and the center moving average Quarter Data for Car Sales Year Quarter Sales (1000's) Moving average (4) Center moving average (baseline) year 1 1 4.8 2 4.1 3 6 4 6.5 Year 2 1 5.8 2 5.2 3 6.8 4 7.4 Year 3 1 6 2 5.6 3 7.5 4 7.8 Year 4 1 6.3 2 5.9 3 8 4 8.4
Parametirc test or not:Test statistic:p-value:decision:Is There A Difference Between the Means?6.7 6.2 3.1 310.3 10 5 5.56.9 5.5 3.3 3.110.5 6.3 4.3 5.44.5 4.6 1.8 25.6 5.6 2 2.65.9 6.1 2.1 2.58 11.7 4 4.68 7.4 3.3 3.15.8 5.2 3.1 2.96 7.3 3.0 3.28.7 5.3 2.7 36 5.5 2.1 2.27.2 6.3 3.5 3.25.9 4.6 2.9 3.46 7.4 3 3.37.2 7.8 3.7 3.48.6 9.4 5.1 5.77.2 8.1 2.8 3.15.8 5.4 2.2 1.83.3 4 1.7 1.86.8 5.1 2 1.83.7 3.5 2.2 2.112...
Q4 A and B Year 1 1 2 3 4 5.2 Q4. The following data show the quarterly sales of Amazing Graphics, Inc. for the years 1 through 3. Quarter Time Period (0) Sales (1000s) 4.8 2 4.1 3 6.0 4 6.5 2 5 5.8 2 6 2 3 7 6.8 2 4 8 7.4 9 6.0 3 2 10 5.6 3 3 11 7.5 3 4 12 8.8 From the above data, it could be concluded that both quarterly...
A comparison was made of the average length of stay (in days) for the years 2000, 2005, 2010, and 2015 between males and females (ages 45–64) for seven diagnoses. The data indicates: 2000 2005 2010 2015 Males: Malignant Neoplasm 9.2 9.4 8.2 7.0 Diabetes Mellitus 7.9 7.3 6.6 6.5 Diseases of the Heart 6.5 5.8 5.0 4.8 Cerebrovascular disease 10.2 10.0 6.2 6.8 Pneumonia 8.0 7.9 7.2 6.9 Injuries and poisoning 6.6 7.2 5.8 5.5 Fractures 7.5 7.2 6.7 6.3...
Q6 3 4 91 Q6. The following data show the quarterly sales of Amazing Graphics, Inc. for the years 1 through 3. Year Quarter Time Period (t) Sales (1000s) 1 2 4.1 6.0 6.5 5.8 5.2 6.8 7.4 3 6.0 510 5.6 13 3 117.5 13 128.8 From the above data, it could be concluded that both quarterly seasonal effects and linear trend in the sales pattern are present. A time series model was considered for this question and the...
A comparison was made of the average length of stay (in days) for the years 2000, 2005, 2010, and 2015 between males and females (ages 45–64) for seven diagnoses. The data indicates: 2000 2005 2010 2015 Males: Malignant Neoplasm 9.2 9.4 8.2 7.0 Diabetes Mellitus 7.9 7.3 6.6 6.5 Diseases of the Heart 6.5 5.8 5.0 4.8 Cerebrovascular disease 10.2 10.0 6.2 6.8 Pneumonia 8.0 7.9 7.2 6.9 Injuries and poisoning 6.6 7.2 5.8 5.5 Fractures 7.5 7.2 6.7 6.3...
The data on the below shows the number of hours a particular drug is in the system of 200 females. Develop a histogram of this data according to the following intervals: Follow the directions. Test the hypothesis that these data are distributed exponentially. Determine the test statistic. Round to two decimal places. (sort the data first) [0, 3) [3, 6) [6, 9) [9, 12) [12, 18) [18, 24) [24, infinity) 34.7 11.8 10 7.8 2.8 20 9.8 20.4 1.2 7.2...
Question 3 of 10 (4 points) | Attempt 1 of 1 | View question in a popup | © 2h 55m Remaining 11.1 Section Exercise 16 (p-value, calc) ol. Baby weights: Following are weights in pounds for random samples of 17 newborn baby boys and baby girls born in Denver in 2011. Box plots indicate that the samples come from populations that are approximately normal. Let u, denote the mean weight of boys. Can you conclude that the mean weight...