Question

Using the data given below, (a) develop the estimated trend line (b) predict sales for october...

Using the data given below, (a) develop the estimated trend line (b) predict sales for october and december of the same year

Sales in millions 2 4 6 5 3
Month Feb Mar April May June
Math   Statistics-And-Probability   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Considering January =1, February =2 and so on,,,,,,,

from above : least square equation: y^ =2.80+0.30x

2)

since for October, x=10

predicted value for October =2.80+0.30*10 =5.8

3)

since for December, x=12

predicted value for December =2.80+0.30*12 =6.4

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Trends and Regression Calculate the Linear Trend Line for the following data Using the Liner Trend...
Trends and Regression Calculate the Linear Trend Line for the following data Using the Liner Trend Line, what sales do you forecast for July 2016 (plot the values) Using the Linear Trend Line, what sales do you forecast for July 2017 (plot the values) Comment on the quality/reliability of your forecasts - what concerns should you have regarding the accuracy of your linear trend line forecast? Select an alternative Trend Line that you think best fits the historical data. Make...
Using the attached LineSpeed data, develop an estimated regression equation to predict the number of defective...
Using the attached LineSpeed data, develop an estimated regression equation to predict the number of defective parts found given the line speed. What is the predicted number of defective parts if the line speed is 45?  Enter your answer rounded to one decimal place. Line Speed Number of Defective Parts Found 20 21 20 19 40 15 30 16 60 14 40 17
Demand for Y is shown in the table. Develop a forecast using a trend line. What...
Demand for Y is shown in the table. Develop a forecast using a trend line. What is the forecast for period 10? Period Y 1 28 2 42 3 49 4 74 5 78 6 93 7 115 8 129
The monthly sales for Yazici Batteries, Inc., were as follows: MONTH SALES January 20 February 21...
The monthly sales for Yazici Batteries, Inc., were as follows: MONTH SALES January 20 February 21 March 15 April 14 May 13 June 16 July 17 August 18 September 20 October 20 November 21 December 23 Plot the monthly sales data. Forecast January sales using each of the following: Naive method. A 3-month moving average. A 6-month weighted average using .1, .1, .1, .2, .2, and .3, with the heaviest weights applied to the most recent months. Exponential smoothing using...
Problem 1: Auto sales at Carmen’s Chevrolet are shown below. Develop a 3-week moving average. Week...
Problem 1: Auto sales at Carmen’s Chevrolet are shown below. Develop a 3-week moving average. Week Auto Sales 1 8 2 10 3 9 4 11 5 10 6 13 7 - Problem 2: Carmen’s decides to forecast auto sales by weighting the three weeks as follows: Weights Applied Period 3 Last week 2 Two weeks ago 1 Three weeks ago 6 Total Problem 3: A firm uses simple exponential smoothing with to forecast demand. The forecast for the week...
The following data represents the monthly electrical expense for an office space over the past three...
The following data represents the monthly electrical expense for an office space over the past three years. You are considering opening a new business in this office space and are preparing an expected budget for your business plan. Month Year 1 Year 2 Year 3 January 170 180 195 February 180 205 210 March 205 215 230 April 230 245 280 May 240 265 290 June 315 330 390 July 360 400 420 August 290 335 330 September 240 260...
Suppose a company has the following sales for the last six months (January – June): Month...
Suppose a company has the following sales for the last six months (January – June): Month Period Sales January 1 16 February 2 25 March 3 20 April 4 20 May 5 31 June 6 35 July 7 26 August 8 (a) Use this information to answer the following 7 questions: ques 1 given the information above 6.Using January through July values, develop a linear trend equation for this time series (to 4 decimals). Please write the equation in the...
A company is investigating the relationship between sales and advertising revenue. Data has been collected on...
A company is investigating the relationship between sales and advertising revenue. Data has been collected on these two variables and is shown below (all figures are in £000s): month jan feb mar april may june july aug sept oct nov dec sales 60 60 58 45 41 33 31 25 24 23 23 23 adv 6.0 6.0 6.0 5.8 4.5 4.1 3.3 3.1 2.5 2.4 2.3 2.3 (a) Plot a scatter diagram of the data given in the table above....
Sales of quit covers at at Jim's departmental store in Australia over the last 12 months...
Sales of quit covers at at Jim's departmental store in Australia over the last 12 months 2017 are shown below Period: Actual Demand: Jan. -20 Feb -21 March -15 April -14 May - 13 June - 16 July - 17 August. - 18 Sep - 20 October. -20 November. - 21 December. -24 Calculate: I. Use a 3- month and 4-month average on all the data and plot averages and the actual demand. II. Using MAD techniques determine which is...
Suppose the yearly trend is $0.45. The information on (detrended) corn prices are given in the...
Suppose the yearly trend is $0.45. The information on (detrended) corn prices are given in the table below. Fill in the missing information in the table and then answer. the sub-questions using the information in the table. (round up to second decimal place) (for number 2) and 3), do not write your answer as Jan and Feb or 1 and 2, but write January or February) (Do not write $ in your answer) Month Year 1 Year 2 Year 3...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT