Question

In: Math

The sales of a company in million dollars) for each year are shown in the table below.


Problem 3: The sales of a company in million dollars) for each year are shown in the table below. 

x (year)20052006200720082009
y (sales)1219293745

a) Find the least square regression line y -ax+b. 

b) Use the least squares regression line as a model to estimate the sales of the company in 2012. 

Solutions

Expert Solution

I used Excel to solve this question.

Que.3

Step.1 Enter data in Excel

Step.2 Go to 'Data' menu ----> 'Data Analysis' ----> Regression.

Step.3 New window will pop up on screen ---> enter X and Y range and output range. You will get following result.

x y SUMMARY OUTPUT
2005 12
2006 19 Regression Statistics
2007 29 Multiple R 0.998868138
2008 37 R Square 0.997737557
2009 45 Adjusted R Square 0.996983409
Standard Error 0.730296743
Observations 5
ANOVA
df SS MS F Significance F
Regression 1 705.6 705.6 1323 4.57036E-05
Residual 3 1.6 0.533333
Total 4 707.2
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept -16830.4 463.4969112 -36.3118 4.59E-05 -18305.45403 -15355.34597 -18305.45403 -15355.34597
X Variable 1 8.4 0.230940108 36.37307 4.57E-05 7.665045508 9.134954492 7.665045508 9.134954492

Que. a

Least square regression line is

Y = 8.4 X - 16830.4

Que.b

When X = 2012, Sale of the company Y is computed as follows:

Y = 8.4 * 2012 - 16830.4

= 70.8

milcah answered 2 years ago
Next > < Previous

Related Solutions

The sales of a company (in million dollars) for each year are shown in the table...
The sales of a company (in million dollars) for each year are shown in the table below. Is there evidence of a linear relationship between the two variables, and are they positively correlated? x (years since 2010) 5 6 7 8 9 y (sales in millions) 12 19 29 37 45                                               a. Assign variables and sketch the scatter gram b. State the Null and Alternative Hypotheses as if a complete hypothesis test had been conducted. c. Find the linear...
The sales of a company (in million dollars) for each year are shown in the table...
The sales of a company (in million dollars) for each year are shown in the table below. Is there evidence of a linear relationship between the two variables, and are they positively correlated? x (years since 2010) 5 6 7 8 9 y (sales in millions) 12 19 29 37 45    a. Assign variables and sketch the scatter gram. b. State the Null and Alternative Hypotheses as if a complete hypothesis test had been conducted. c. Find the linear...
The sales of a company (in million dollars) for each year are shown in the table below. Is there evidence of a linear relationship between the two variables, and are they positively correlated?
The sales of a company (in million dollars) for each year are shown in the table below. Is there evidence of a linear relationship between the two variables, and are they positively correlated? x (years since 2010) 5 6 7 8 9 y (sales in millions) 12 19 29 37 45                                                                                                                                              a.         Assign variables and sketch the scatter gram (2)             b.         State the Null and Alternative Hypotheses as if a complete hypothesis test had been conducted. (2)             c.         Find the linear...
An auto dealer's sales numbers are shown in the table below. Find for each month the...
An auto dealer's sales numbers are shown in the table below. Find for each month the mean, median, and mode prices of the cars she sold. Round your answers to the nearest dollar. Number sold Price May June July $25,000 22 25 24 $15,000 49 24 24 $13,500 25 49 49 June mean     $ median     $ mode     $ July mean     $ median     $ mode     $
An auto dealer's sales numbers are shown in the table below. Find for each month the...
An auto dealer's sales numbers are shown in the table below. Find for each month the mean, median, and mode prices of the cars she sold. Round your answers to the nearest dollar. Number sold Price May June July $25,000 22 25 24 $15,000 49 24 24 $13,500 25 49 49 May mean     $ median     $ mode     $ June mean     $ median     $ mode     $ July mean     $ median     $ mode    
Sales 3 million dollars per year Cost of goods 1.7 million dollars per year Cash Expenses...
Sales 3 million dollars per year Cost of goods 1.7 million dollars per year Cash Expenses 725 thousand dollars per year Depreciation Expense 125 thousand dollars per year Cash on the balance sheet 150 thousand dollars Receivables on the balance sheet 75 thousand dollars Inventory on the balance sheet 300 thousand dollars Fixed asset net of depreciation on the balance sheet 450 thousand dollars Total Current Liabilities on the balance sheet 175 thousand dollars Total Long Term Debt on the...
A Company produces two products. Relevant information for each product is shown in the Table below....
A Company produces two products. Relevant information for each product is shown in the Table below. The company has a goal of $48 in profits and incurs $1 penalty for each dollar it falls short of this goal. A total of 32 hours of labor are available. A $2 penalty is incurred for each hour of overtime (labor over 32 hours) used, and $1 penalty is incurred for each hour of available labor that is unused. Marketing considerations require at...
FOR EACH OF THE CASES SHOWN IN THE TABLE BELOW, CALCULATE THE FUTURE VALUE OF THE...
FOR EACH OF THE CASES SHOWN IN THE TABLE BELOW, CALCULATE THE FUTURE VALUE OF THE SINGLE CASH FLOW DEPOSITED TODAY THAT WILL BE AVAILABLE AT THE END OF THE DEPOSIT PERIOD IF THE INTEREST IS COMPOUNDED ANNUALLY, SEMI ANNUALLY AND QUARTERLY AT THE RATE SPECIFIED OVER THE GIVEN PERIOD. CASE CASH FLOW INTEREST RATE DEPOSIT PERIOD (YEARS) ORDINARY ANNUITY ANNUITY DUE A $750 8% 10 B $3,250 12% 8 C $9,500 16% 20 D $10,000 20% 4
The payoff table below provides the profits (in thousands of dollars) for each of four alternatives...
The payoff table below provides the profits (in thousands of dollars) for each of four alternatives in each of three supplies. Supplies Alternative S1 S2 S3 A1 112 67 -26 A2 82 85 101 A3 85 72 80 A4 -50 90 110 Suppose that the probabilities for the supplies above are P(S1) = 0.6, P(S2) = 0.2, and P(S3) = 0.1. Which alternative should be selected under Bayes’ Rule? What is the expected value of perfect information for this decision?
Shown below are the budgeted sales for ABC Company for the next six months: Sales for...
Shown below are the budgeted sales for ABC Company for the next six months: Sales for Cash Sales on Account January $18,000 $ 95,000 February $15,000 $130,000 March $24,000 $ 70,000 April $26,000 $120,000 May $19,000 $ 90,000 June $14,000 $100,000 On average, 45% of the sales on account are collected in the month of sale, 30% are collected in the month following sale, 15% are collected in the second month following sale, and the remaining 10% is collected three...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT