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) | 2005 | 2006 | 2007 | 2008 | 2009 |
|---|---|---|---|---|---|
| y (sales) | 12 | 19 | 29 | 37 | 45 |
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 1 year agoRelated 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
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...
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 $15,000 $110,000
February $18,000 $125,000
March $26,000 $119,000
April $24,000 $140,000
May $14,000 $ 88,000
June $18,000 $137,000
On average, 25% of the sales on account are collected in the month
of sale, 30% are collected in the month following sale, 35% are
collected in the second month following sale, and the remaining
10% is collected three months after...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- There are three horses in a race. Historical records show that the time it takes each...
- We have 95 students in a class. Their abilities/eagerness are uniform randomly distributed on a scale...
- Answer All Parts Of The Following Question A. ) Why, in the absence of technological change,...
- In the New Keynesian Macroeconomics business cycles are driven by demand shocks, while in the New...
- In Mary Pardo’s “Grassroots Activism: Mothers of East Los Angeles” the author links the social networks...
- Which part of the supply chain link is responsible for managing it?
- The following returns have been estimated for Security T and Security S: Scenario Security T Security...
ADVERTISEMENT