Question

In: Statistics and Probability

5) Based on quarterly data collected over the last four years, the following regression equation was...

5) Based on quarterly data collected over the last four years, the following regression equation was found to forecast the quarterly demand for the number of new copies of an economics textbook: t= 3,305 – 665 Qtr1 – 1,335 Qtr 2 + 305 Qtr3, where Qtr1,Qtr2, and Qtr3 are dummy variables corresponding to Quarters 1, 2, and 3. The demand forecast for Quarter 2 of the next year is ________.

A) 2,640

B) 1,970

C) 3,610

D) 3,305

2) In a two-way ANOVA test, how many null hypotheses are tested?

A) 1

B) 1 or 2

C) 2 or 3

D) More than 3

3) The following is an incomplete ANOVA table.

source of variation ss df ms f
between groups 2 12.5
within groups
total 100 10

For the within groups category, the degrees of freedom are ________.

A) 6

B) 7

C) 8

D) 9

6) Costco sells paperback books in their retail stores and wants to examine the relationship between the prices and sales. The price of a particular novel was adjusted each week and the weekly sales are in the following table. Management would like to use a simple linear regression model that uses prices to predict sales.

sales prices
7 12
4 11
5 10
9 9
8 8
8 7
7 7

The predicted weekly sales for the novel when priced at $10 is equal to ________.

A) 4.60

B) 5.07

C) 6.45

D) 7.33

2) Which of the following is the 95% confidence interval for the regression coefficient β1 if df=30, b1= −2 and s= 3?

A) [−5.00, −1.00]

B) [−7.88, 3.88]

C) [−7.09, 3.09]

D) [−8.13, 4.13]

Solutions

Expert Solution

5) t = 3305 - 665 Qtr1 - 1335 Qtr 2 + 305 Qtr3,

The demand forecast for Quarter 2 of the next year is

t = 3305 - 665*0 -1335*1 + 305*0 = 1970

Answer B)

-------------

2) In a two-way ANOVA test, number of null hypotheses that are tested:

Answer: C) 2 or 3

----

3)

For the within groups category, the degrees of freedom are 10-2 = 8

Answer: C) 8

---

4)

X Y XY
12 7 84 144 49
11 4 44 121 16
10 5 50 100 25
9 9 81 81 81
8 8 64 64 64
7 8 56 49 64
7 7 49 49 49
Ʃx = Ʃy = Ʃxy = Ʃx² = Ʃy² =
64 48 428 608 348
Sample size, n = 7
x̅ = Ʃx/n = 64/7 = 9.142857143
y̅ = Ʃy/n = 48/7 = 6.857142857
SSxx = Ʃx² - (Ʃx)²/n = 608 - (64)²/7 = 22.85714286
SSyy = Ʃy² - (Ʃy)²/n = 348 - (48)²/7 = 18.85714286
SSxy = Ʃxy - (Ʃx)(Ʃy)/n = 428 - (64)(48)/7 = -10.8571429

Slope, b = SSxy/SSxx = -10.85714/22.85714 = -0.475

y-intercept, a = y̅ -b* x̅ = 6.85714 - (-0.475)*9.14286 = 11.2

Regression equation :

ŷ = 11.2 + (-0.475) x

Predicted value of y at x = 10

ŷ = 11.2 + (-0.475) * 10 = 6.45

Answer: C) 6.45

--------------

5)

Critical value, t_c = T.INV.2T(0.05, 30) = 2.0423

95% Confidence interval for slope:

Lower limit = b1 - tc*se(b1) = -2 - 2.0423*3 = -8.13

Upper limit = b1 + tc*se(b1) = -2 + 2.0423*3 = 4.13

Answer: D) [−8.13, 4.13]


Related Solutions

Sales data were collected from a small bookstore. The following is an equation for the regression...
Sales data were collected from a small bookstore. The following is an equation for the regression line of the data. Sales = 9.12 + 0.818(Number of Salespeople Working) The assumptions and conditions for regression are​ met, and from​ technology, it is known that SE(b1) = 0.0920 and Se =1.640. Number of Salespeople Working // Sales (in $1000s) 1 // 11 2 // 10 6 // 12 9 // 16 9 // 18 10 // 20 13 // 19 14 //...
1.Assume you collected a quarterly sales data (in millions of dollars) over a four-year period from...
1.Assume you collected a quarterly sales data (in millions of dollars) over a four-year period from the first quarter 2016 to the fourth quarter 2019, and computed the seasonal index for each quarter. If the values of the actual sales and deseasonalised sales were 162 and 158.68, respectively, in the second quarter of 2016, what is the (normalised) seasonal index for the second quarter? Round your answer to two decimal places. 2. Assume you collected data representing the number of...
5) Draw the trend analysis based on following sales data for four years and analyse the...
5) Draw the trend analysis based on following sales data for four years and analyse the fifth-year projected sales. Mention the possible relationship between the sales and the year on the basis of linear regression. Also mention the R-square value and its interpretation. Year Sales 1 900 2 1100 3 1200 4 1450 5
Determine the regression equation (write the regression equation) of the following data, where Y is the...
Determine the regression equation (write the regression equation) of the following data, where Y is the dependant variable and X is the predictor: X Y 5 85 4 103 6 70 5 82 5 89 5 98 6 66 6 95 2 169 7 70 7 48 b) Interpret the regression coefficients. c) Graph the regression line. d) Use the regression equation to predict Y for X=3. e) Compute the coefficient of determination. f) Interpret the coefficient of determination. g)...
2. The following data were collected last semester on ten students. Complete a multiple regression analysis...
2. The following data were collected last semester on ten students. Complete a multiple regression analysis in which you use AGE (A), MATH PROFICIENCY (MP) (on a 1 –10 scale), and GENDER (G) (0 = male, 1 = female) as predictors of FINAL EXAM (FE) performance. Do this analysis in SPSS and then answer the following questions. Subject # A MP G FE 1 35 8 1 90 2 31 6 0 88 3 26 5 1 84 4 33...
The following data were collected last semester on ten ERM 681 students. Complete a multiple regression...
The following data were collected last semester on ten ERM 681 students. Complete a multiple regression analysis in which you use AGE (A), MATH PROFICIENCY (MP) (on a 1 –10 scale), and GENDER (G) (0 = male, 1 = female) as predictors of FINAL EXAM (FE) performance. Do this analysis in SPSS and then answer the following questions. Subject # A MP G FE 1 35 8 1 90 2 31 6 0 88 3 26 5 1 84 4...
The following data is the unemployment rate in a metropolitan community over the last 10 years....
The following data is the unemployment rate in a metropolitan community over the last 10 years. Use exponential smoothing with a smoothing constant of a = 0.2, 0.4, 0.6, and 0.8 to find the best forecast for unemployment for next year. Using mean absolute deviation which forecast constant provides the best prediction of unemployment? Why? Year Rate Year Rate 1 7.2 6 5.5 2 7.0 7 6.7 3 6.2 8 7.4 4 5.0 9 6.8 5 5.3 10 6.1
Using a series of data collected quarterly (20 years), XYZ University has modelled the demand and...
Using a series of data collected quarterly (20 years), XYZ University has modelled the demand and supply function of their program offering as below: Qd = 16,000 - 4000P Qs = -9,000 + 6000P Note: P is fees (,000) per subject b. At the current equilibrium fees, the government believes that poor people deprive of a good education, and hence, enforce that the university should only charge the fees at RM 2,000 per subject. i. Based on the above scenario,...
Consider the following data:   and   What is the sample regression equation?
Consider the following data:   and   What is the sample regression equation?
Jace collected the following data on the quarterly room occupancy (in hundreds) for a resort hotel...
Jace collected the following data on the quarterly room occupancy (in hundreds) for a resort hotel in Iowa. Year quarter Occupancy 2013 1 16 2 21 3 9 4 18 2014 1 15 2 20 3 10 4 18 2015 1 17 2 24 3 13 4 22 2016 1 17 2 25 3 11 4 21 2017 1 18 2 26 3 14 4 25 Plot the data and describe any trend and seasonal effects you observe in the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT