Homework Answers
Regression line y=0.409 x+2.963
When x=18
Then, y=0.409 *18 +2.963 =10.325
So 18th month forecast =10.325
This will be a good approach for the forecasting provided that dependent variable pattern continues as in the past.
He main concerns are that the data after 18th will not be provided and thus the patterns in them is not precise which can lead to some forecast errors.
Add Answer to:
Using the Linear Regression Fit Line: y=0.409x+2.963, calculate a forecast for the 18th month. 2 Pts...
HELP ASAP Suppose you are wishing to fit a multiple linear regression model using one categorical...
HELP ASAP
Suppose you are wishing to fit a multiple linear regression model using one categorical variable that can take on 17 different values. For example, if you wished to use the months of the year in your model, the categorical variable "month" would have 12 different values: January, February, March, etc. In general, how many dummy variables would you need to incorporate into your model to completely capture the effect of all 17 conditions of a categorical variable on...
HW8_4 Fit the data in the table using linear regression. Plot the data points as well as the regr...
Please write the codes in
MATLAB.
HW8_4 Fit the data in the table using linear regression. Plot the data points as well as the regression line. Determine the value of y whenx = 7.2 and print it to the screen using fprintf Then repeat the process, regressing in the opposite way (x vs y) to find the equation of the line needed to determine the value of x when y is 15 Optional brain food: Do you get the same...
excel spreadsheet information: Month Sales (in millions of boxes) 1 1306 2 1305 3 1311 4...
excel spreadsheet information:
Month
Sales (in millions of boxes)
1
1306
2
1305
3
1311
4
1313
5
1324
6
1329
7
1346
8
1347
9
1378
10
1394
11
1441
12
1469
Problem 3 You have realized that the sales for Select-A-Size Paper Towel packs have been increasing over the past year. You have learned that the double exponential smoothing method can account for such a trend in the data. Use double (trend-adjusted) exponential smoothing method to forecast sales...
Questions 23-24: A simple linear regression model was fit to the following situation: using the number...
Questions 23-24: A simple linear regression model was fit to the following situation: using the number of pages in a book in hundreds to predict the number of typos in the book. The equation is y = 1.2 + 3.4x. 24. Explain what it would mean if an actual 500-page book had a residual of -3.2.:* O a. This particular book is definitely an outlier and should be dropped from the model. Ob. This particular book had a predicted value...
Problem 2.2: Linear Regression. Suppose that I am trying to estimate Starbucks stock price with a...
Problem 2.2: Linear Regression. Suppose that I am trying to estimate Starbucks stock price with a linear regression model. The Day and Volume are being used as my X1 and X2. a) Calculate the forecast for November 1 if Volume is 8000 b) Should I be using both Day and Volume as predictors of stock price? (Use Regression result output below) c) Does the data truly have a downward trend? How could I prove it from the Regression result output?...
This is a table to show how to calculate a three-month moving average. Please use this...
This is a table to show how to calculate a three-month moving average. Please use this same data to calculate a four-month moving average. ACTUAL SHED SALES 10 12 13 16 19 23 26 30 28 18 16 MONTH 3-MONTH MOVING AVERAGE January March (10+ 12 + 13)3 -11.67 (12 13+ 16/3-13.67 (13 + 16 + 19)/3# 16.00 (16 + 19 +23Y3- 19.33 19 +23 + 26V3-22.67 (23+26 +30/3-26.33 (26+30 +28)V3-28.00 (30 +28 + 18/3-25.33 (28 + 18 + 163-20.67...
II) (10 marks) The number of pounds of steam used per month by a chemical plant is thought to be ...
II) (10 marks) The number of pounds of steam used per month by a chemical plant is thought to be related to the average ambient temperature (in F) for that month. An investigator has collected the past year's usage and temperature in a table. Some summary statistics related to this dataset are provided y-5062.212x,2-29256, n 12 , x,-558, y,2 2416144 Xiy.-265864.6, (yi-%)2-37.746 Month Temp. Usage/1000 Jan 21 Feb 24 Mar. 32 Apr. 47 May 50 June 59 July 68 Aug....
Please use Excel, and show all functions. 3. Answer the following question for where Y has...
Please use Excel, and show all functions.
3. Answer the following question for where Y has been regressed on X1, X2, and X3. Use the linear regression output in the Excel file. Your answers should be rounded to 2 decimal places. a. What is the equation for the line of best fit or regression line? b. The proportion is for the amount of the variability of Y that is explained or accounted for by the model. C. The correlation between...
please help ! Week 3 Simple Regression Forecasting Sales Problem Homework Assignment Using the Excel file...
please help !
Week 3 Simple Regression Forecasting Sales Problem Homework Assignment Using the Excel file Forecasting Sales Using Ad Dollars Data use Excel to create a forecast of Sales $ using Ad $. Analyze the data using simple linear regression in Excel to answer the following questions. 1. Does more ad spending increase, decrease, or have no effect on sales $? 2. What is the regression equation? Write it and its numerical values. 3. Using the regression equation calculate...
You are not sure that the forecasting technique that your company is using is correct for...
You are not sure that the forecasting technique that your company is using is correct for two items that you manage. At this time you want to consider several new options and pick the one that reduces the amount of forecast error. To accomplish this task you will use the data listed below. Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 stereo system 22...
HELP ASAP
Suppose you are wishing to fit a multiple linear regression model using one categorical variable that can take on 17 different values. For example, if you wished to use the months of the year in your model, the categorical variable "month" would have 12 different values: January, February, March, etc. In general, how many dummy variables would you need to incorporate into your model to completely capture the effect of all 17 conditions of a categorical variable on...
Please write the codes in
MATLAB.
HW8_4 Fit the data in the table using linear regression. Plot the data points as well as the regression line. Determine the value of y whenx = 7.2 and print it to the screen using fprintf Then repeat the process, regressing in the opposite way (x vs y) to find the equation of the line needed to determine the value of x when y is 15 Optional brain food: Do you get the same...
excel spreadsheet information:
Month
Sales (in millions of boxes)
1
1306
2
1305
3
1311
4
1313
5
1324
6
1329
7
1346
8
1347
9
1378
10
1394
11
1441
12
1469
Problem 3 You have realized that the sales for Select-A-Size Paper Towel packs have been increasing over the past year. You have learned that the double exponential smoothing method can account for such a trend in the data. Use double (trend-adjusted) exponential smoothing method to forecast sales...
Questions 23-24: A simple linear regression model was fit to the following situation: using the number of pages in a book in hundreds to predict the number of typos in the book. The equation is y = 1.2 + 3.4x. 24. Explain what it would mean if an actual 500-page book had a residual of -3.2.:* O a. This particular book is definitely an outlier and should be dropped from the model. Ob. This particular book had a predicted value...
Problem 2.2: Linear Regression. Suppose that I am trying to estimate Starbucks stock price with a linear regression model. The Day and Volume are being used as my X1 and X2. a) Calculate the forecast for November 1 if Volume is 8000 b) Should I be using both Day and Volume as predictors of stock price? (Use Regression result output below) c) Does the data truly have a downward trend? How could I prove it from the Regression result output?...
This is a table to show how to calculate a three-month moving average. Please use this same data to calculate a four-month moving average. ACTUAL SHED SALES 10 12 13 16 19 23 26 30 28 18 16 MONTH 3-MONTH MOVING AVERAGE January March (10+ 12 + 13)3 -11.67 (12 13+ 16/3-13.67 (13 + 16 + 19)/3# 16.00 (16 + 19 +23Y3- 19.33 19 +23 + 26V3-22.67 (23+26 +30/3-26.33 (26+30 +28)V3-28.00 (30 +28 + 18/3-25.33 (28 + 18 + 163-20.67...
II) (10 marks) The number of pounds of steam used per month by a chemical plant is thought to be related to the average ambient temperature (in F) for that month. An investigator has collected the past year's usage and temperature in a table. Some summary statistics related to this dataset are provided y-5062.212x,2-29256, n 12 , x,-558, y,2 2416144 Xiy.-265864.6, (yi-%)2-37.746 Month Temp. Usage/1000 Jan 21 Feb 24 Mar. 32 Apr. 47 May 50 June 59 July 68 Aug....
Please use Excel, and show all functions.
3. Answer the following question for where Y has been regressed on X1, X2, and X3. Use the linear regression output in the Excel file. Your answers should be rounded to 2 decimal places. a. What is the equation for the line of best fit or regression line? b. The proportion is for the amount of the variability of Y that is explained or accounted for by the model. C. The correlation between...
please help !
Week 3 Simple Regression Forecasting Sales Problem Homework Assignment Using the Excel file Forecasting Sales Using Ad Dollars Data use Excel to create a forecast of Sales $ using Ad $. Analyze the data using simple linear regression in Excel to answer the following questions. 1. Does more ad spending increase, decrease, or have no effect on sales $? 2. What is the regression equation? Write it and its numerical values. 3. Using the regression equation calculate...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago