In: Statistics and Probability
In a recent survey concerning company sales and net earnings, 15 companies responded with the following information.
Company | Sales ($ thousands) |
Net Earnings ($ thousands) |
---|---|---|
Runners | 54.8 | 4.1 |
NorthCo | 24.0 | 0.8 |
JenStar | 42.6 | 2.2 |
Text Tech | 57.6 | 4.2 |
Capital Consultants | 56.7 | 3.6 |
Financial Services | 34.9 | 1.8 |
Cantu Excavating | 49.5 | 2.8 |
Pace Design | 25.7 | 1.0 |
CanTech Supply | 21.4 | 0.4 |
Second Time Around Clothing | 25.3 | 0.7 |
Echo Systems | 23.1 | -0.1 |
Antique Accents | 51.3 | 3.5 |
Spin Master Toys | 52.4 | 3.7 |
XYZ Co. | 37.1 | 1.3 |
Stiller Co. | 40.9 | 2.6 |
a) Using a statistical computing tool, find the
equation of the regression line.
For full marks your answer should be accurate to at least three
decimal places.
ŷ = ? + ?x
b) Use the regression line from part a to estimate
the net earnings for a company with sales of $54.8 thousand.
For full marks your answer should be accurate to at least one
decimal place.
Earnings: ?
c) | Given the regression equation from part a, which of the
following statements is most appropriate regarding company sales
and earnings?
|
Here' the answer to the question. Please let me know in case you've doubts.
What I've done is performed a linear regression exercise in Excel for predicting Net earnings from Sales. You can find this in the image below.
The regression table below is used to get the
1. Regression equation. y^ = 1.993 + 0.105*X
2. From the regression equation, we sub the value of X to get Y^ or predicted Net Earnings.
It is $3.761 units or $3761.00 ( to 2 decimals as asked in the question)