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 Quarter (1000's)(4 4.8 4.1 Year (baseline year 1 4 6.5 5.8 5.2 6.8 7.4 Year 2 2 4 Year 3 5.6 7.5 7.8 6.3 5.9 4 Year 4 4 8.4 Attach File
Homework Answers
From the given data
| 4 Cells | Centered moving average | ||||
| Year 1 | Quarter | Sales | Moving average | 4 cells average | 2 Cells average |
| 1 | 4.8 | ||||
| 2 | 4.1 | 5.35 | |||
| 3 | 6 | 5.6 | 5.475 | ||
| 4 | 6.5 | 5.875 | 5.7375 | ||
| Year 2 | 1 | 5.8 | 5.35 | 6.075 | 5.975 |
| 2 | 5.2 | 5.6 | 6.3 | 6.1875 | |
| 3 | 6.8 | 5.875 | 6.35 | 6.325 | |
| 4 | 7.4 | 6.075 | 6.45 | 6.4 | |
| Year 3 | 1 | 6 | 6.3 | 6.625 | 6.5375 |
| 2 | 5.6 | 6.35 | 6.725 | 6.675 | |
| 3 | 7.5 | 6.45 | 6.8 | 6.7625 | |
| 4 | 7.8 | 6.625 | 6.875 | 6.8375 | |
| Year 4 | 1 | 6.3 | 6.725 | 7 | 6.9375 |
| 2 | 5.9 | 6.8 | 7.15 | 7.075 | |
| 3 | 8 | 6.875 | |||
| 4 | 8.4 | 7 |
Add Answer to:
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 Cent...
Exercise 1. Graph three plots Sales, Forecast, center moving average 2. Predict the sales in year...
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
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 (ba...
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
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 Movin...
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...
Q4 A and B Year 1 1 2 3 4 5.2 Q4. The following data show...
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...
The data on the below shows the number of hours a particular drug is in the...
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...
Q6 3 4 91 Q6. The following data show the quarterly sales of Amazing Graphics, Inc....
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...
An object of weight 1 N is falling vertically. The time vs. speed data can be...
An object of weight 1 N is falling vertically. The time vs. speed data can be found here. In this case the effect of air-drag cannot be neglected. Use your critical thinking to estimate the air-drag coefficient . Make sure you include the units in your answer. 0 0 0.1 0.9992 0.2 1.993 0.3 2.978 0.4 3.948 0.5 4.898 0.6 5.826 0.7 6.728 0.8 7.599 0.9 8.438 1 9.242 1.1 10.01 1.2 10.74 1.3 11.43 1.4 12.09 1.5 12.7 1.6 ...
• 1. What are the quarterly growth rates (Percentage Change From Preceding Period in Real Gross...
• 1. What are the quarterly growth rates (Percentage Change From Preceding Period in Real Gross Domestic Product) for the U.S. economy for the last six quarters? Report those numbers in your submission 2. What is the average of those 6 quarters? . 3. Is the average of those growth rates above or below the long-run U.S. annual growth rate of 3.5 percent? Bureau of Economke Analysis Table 1.1.1. Percent Change From Preceding Period in Real Gross Domestic Product Percent...
QUESTION 7 The data set Beer Large, which can be found in StatCrunch Shared Data Sets,...
QUESTION 7 The data set Beer Large, which can be found in StatCrunch Shared Data Sets, gives the Alcohol, Carbohydrates and Calories for different brands of beer. The explanatory variable is x + Carbohydrates and the response variable is Y - Calories. Use this information to answer: Calculate the correlation between carbohydrates and calories. (4 decimal places) Row vars varo var var 8 var9 var 10 2 الميا ABV 4.1 5.4 4.43 4.13 5.9 4.9 Carbs 2.6 13.7 5.8 5...
5. The quarterly sales data for three consecutive years are listed in the table below Year Quarter Sales MA CMA Index 0S0 1 1690 1938.75 2 940 19662 3 2625 1956.25 1952.5 1.34443 2500 2025 1961.25...
5. The quarterly sales data for three consecutive years are listed in the table below Year Quarter Sales MA CMA Index 0S0 1 1690 1938.75 2 940 19662 3 2625 1956.25 1952.5 1.34443 2500 2025 1961.25 1.27469 1800 1990 1990.625 0904239 900 2002.5 2007.5 0.448319 2900 2052.5 1996.25 1.452724 8 | 2360 | 2060 | 20275|1.163995 9 1850 2123.75 2056.25 0.899696 10 I 1100 2091.875 0.525844 11 2930 12 2615 MA refers to Moving Average computed with N 1 CMA...
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...
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...
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...
• 1. What are the quarterly growth rates (Percentage Change From Preceding Period in Real Gross Domestic Product) for the U.S. economy for the last six quarters? Report those numbers in your submission 2. What is the average of those 6 quarters? . 3. Is the average of those growth rates above or below the long-run U.S. annual growth rate of 3.5 percent? Bureau of Economke Analysis Table 1.1.1. Percent Change From Preceding Period in Real Gross Domestic Product Percent...
QUESTION 7 The data set Beer Large, which can be found in StatCrunch Shared Data Sets, gives the Alcohol, Carbohydrates and Calories for different brands of beer. The explanatory variable is x + Carbohydrates and the response variable is Y - Calories. Use this information to answer: Calculate the correlation between carbohydrates and calories. (4 decimal places) Row vars varo var var 8 var9 var 10 2 الميا ABV 4.1 5.4 4.43 4.13 5.9 4.9 Carbs 2.6 13.7 5.8 5...
5. The quarterly sales data for three consecutive years are listed in the table below Year Quarter Sales MA CMA Index 0S0 1 1690 1938.75 2 940 19662 3 2625 1956.25 1952.5 1.34443 2500 2025 1961.25 1.27469 1800 1990 1990.625 0904239 900 2002.5 2007.5 0.448319 2900 2052.5 1996.25 1.452724 8 | 2360 | 2060 | 20275|1.163995 9 1850 2123.75 2056.25 0.899696 10 I 1100 2091.875 0.525844 11 2930 12 2615 MA refers to Moving Average computed with N 1 CMA...
Most questions answered within 3 hours.
-
A 0.035 mol sample of a weak acid, HA, is dissolved in 437 mL of
water...
asked 3 minutes ago -
a sample of Ar gas has a volume of 6.30 L with an unknown
pressure. the...
asked 4 minutes ago -
The
serum cholesterol levels of a population of kids follow a normal
distribution with mean 155...
asked 24 minutes ago -
han discusses the racist practice of badlands, a bar
in the Castro
district of San Francisco,...
asked 36 minutes ago -
A sample of final exam scores is normally distributed with a
mean equal to 25 and...
asked 39 minutes ago -
An investor shorts 100 shares of a stock when the share price is
$50 and closes...
asked 43 minutes ago -
LLOP corporation just paid 4$ dividend per share, you expect the
dividend to grow 8% for...
asked 53 minutes ago -
if we subtract 1000 from 0001 is there overflow? (binary)
asked 1 hour ago -
Hello, I need help with the function below, The language I am
using is Ocaml
open...
asked 1 hour ago -
Explain how the presence of glucose represses the gal structural
genes?
asked 1 hour ago -
For the reaction CaI2+2AgNO3⟶2AgI+Ca(NO3)2 how many grams of
silver iodide, AgI, are produced from 56.5 g...
asked 1 hour ago -
Write an equation for hydrolysis via acid catalysis.
Using ethyl acetate, ethyl benzoate, ethyl formate or...
asked 1 hour ago