Question: PLEASE COMPLETE WORK IN EXCEL SPREADSHEET ONLY. SHOW ALL FORMULAS/FUNCTIONS TO SHOW ANSWERS AND EXPLAIN TO ME HOW YOU GOT THE ANSWER. DO NOT WRITE
PLEASE COMPLETE WORK IN EXCEL SPREADSHEET ONLY. SHOW ALL FORMULAS/FUNCTIONS TO SHOW ANSWERS AND EXPLAIN TO ME HOW YOU GOT THE ANSWER. DO NOT WRITE IT DOWN IN A PIECE OF PAPER.
Arnold Tofu owns and operates a chain of 12 vegetable protein "hamburger" restaurants in northern Louisiana. Sales figures and profits for the stores are provided in the table below. Sales are given in millions of dollars; profits are in hundreds of thousands of dollars. Calculate a regression line for the data. What is your forecast of profit for a store with sales of $24 million? $30 million? How strong (or weak) is the relation between sales and profits?
| Store | Profits | Sales |
| 1 | 14 | 6 |
| 2 | 11 | 3 |
| 3 | 15 | 5 |
| 4 | 16 | 5 |
| 5 | 24 | 15 |
| 6 | 28 | 18 |
| 7 | 22 | 17 |
| 8 | 21 | 12 |
| 9 | 26 | 15 |
| 10 | 43 | 20 |
| 11 | 34 | 14 |
| 12 | 9 | 5 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
