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

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 Mathematics Questions!