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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!