Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved 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

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Statistics For Contemporary Decision Making

Authors: Black Ken

8th Edition

978-1118494769, 1118800842, 1118494768, 9781118800843, 978-1118749647

More Books

Students also viewed these Mathematics questions

Question

=+e) What probably happened to earnings after the initial 17 days?

Answered: 1 week ago