Question: build the regression tables using the Data tab and Data Analysis ribbon or by using Excel formulas. Please include the Excel formulas in the answer
build the regression tables using the Data tab and Data Analysis ribbon or by using Excel formulas.
Please include the Excel formulas in the answer
| Sales x | Inventory y |
| 5,873,050 | 97,884 |
| 8,882,600 | 148,043 |
| 6,449,100 | 107,485 |
| 4,512,200 | 69,418 |
| 4,021,500 | 63,833 |
| 4,529,600 | 69,686 |
| 5,094,000 | 77,182 |
| 5,330,700 | 80,768 |
| 5,188,700 | 78,617 |
| 6,094,200 | 92,336 |
| 8,781,800 | 133,058 |
| 8,161,100 | 108,815 |
| 3,931,500 | 52,420 |
| 3,476,400 | 46,352 |
| 4,185,900 | 55,812 |
| 2,897,000 | 38,627 |
| 4,264,800 | 55,387 |
| 6,508,700 | 84,529 |
| 3,992,800 | 51,190 |
| 4,666,300 | 58,329 |
| 3,575,900 | 44,699 |
| 3,332,500 | 41,656 |
| 4,185,100 | 52,314 |
| 5,346,000 | 66,825 |
| 2,691,200 | 33,225 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
