Question: Use the attached data table to build the regression tables using the Data tab and Data Analysis ribbon or by using Excel formulas. Sales Inventory
Use the attached data table to build the regression tables using the Data tab and Data Analysis ribbon or by using Excel formulas.
| Sales | Inventory |
| 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
