Multiple regression analysis

Please see attached file for full problem description.

Ques. 1: Suppose that the sales manager of a large automotive parts distributor wants to estimate as early as April, the total annual sales of a region. Based on regional sales, the total sales for the company can also be estimated. If, based on past experience, it is found that the April estimates of annual sales reasonably accurate, then in future years the April forecast could be used to revise production schedules and maintain the correct inventory at the retail outlets.
Several factors appear to be related to sales, including the number of retail outlets in the region stocking the company’s parts, the number of automobiles in the region registered as of April 1, and the total personal income for the first quarter of the year. A total of five independent variables were finally selected as being the most important (according to the sales manager). Then the data were gathered for a table that for region 1 were 1.139 retail outlets stocking the company’s automotive parts, there were 9,270,000 registered automobiles in the region as of April 1, and sales for that year were $ 37, 702, 000
Annual Sales ($Mil) # of Retail outlets # of automobiles ($Mill) income ($Bill) avg. age of autos # of supervisors
Y X1 X2 X3 X4 X5
37.702 1739 9.27 85.4 3.5 9.0
24.196 1221 5.86 60.7 5.0 5.0
32.055 1646 8.81 68.1 4.4 7.0
3.611 120 3.81 20.2 4.0 5.0
17.625 1096 10.31 33.8 3.5 7.0
45.919 2290 11.62 95.1 4.1 13.0
29.600 1687 8.96 69.3 4.1 15.0
8.114 241 6. 28 16.3 5.9 11. 0
20.116 649 7.77 34.9 5.5 16.0
12.994 1427 10.92 15.1 4.1 10.0

Ques: What are the predicted Annual Sales for 1,946 retail outlets, 8.65 million registered automobiles, personal income of 93.2 billion, average age of automobile of 4.8 years, and number of supervisors 12?
NB: on the worksheet, list Annual Sales and the Independent variables beginning with X5. Be sure to highlight 3 rows and 6 columns before you type your LINEST function.

Quest. 2: The administrator of a new paralegal program at Seagate Technical College wants to estimate the grade point average in the new program. He thought that high school GPA, the verbal score on the Scholastic Aptitude Test (SAT), and the mathematics score on the SAT would be good predictors of paralegal GPA. The data on nine students are:

Student High Sch. GPA SAT (verbal) SAT (math) Paralegal GPA
1 3.25 480 410 3.21
2 1.80 290 270 1.68
3 2.89 420 410 3.58
4 3.81 500 600 3.92
5 3.13 500 490 3.00
6 2.81 430 460 2.82
7 2.20 320 490 1.65
8 2.14 530 480 3.30
9 2.63 469 440 2.33
QUES: What is the predicted Paralegal GPA for a high School GPA of 3.53, a Verbal SAT of 560, and a Math SAT of 450?
NB: On your worksheet, list Paralegal GPA last and the independent variables beginning with the math SAT. Be sure to highlight 3 rows and 4 columns before you type your LINEST function.

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with TheBestPaperWriters
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Business Studies
Job well done. Finish paper faster than expected. Thank you!
Customer 452451, October 3rd, 2022
Architecture, Building and Planning
The assignment was well written and the paper was delivered on time. I really enjoyed your services.
Customer 452441, September 23rd, 2022
The paper was EXCELLENT. Thank you
Customer 452449, September 23rd, 2022
excellent loved the services
Customer 452443, September 23rd, 2022
Business Studies
Thank you!
Customer 452451, November 27th, 2022
Job well done and completed in a timely fashioned!
Customer 452451, November 18th, 2022
Business Studies
Excellent service - thank you!
Customer 452469, February 20th, 2023
English 101
Very good job. I actually got an A
Customer 452443, September 25th, 2022
Public Administration
Excellent timely work
Customer 452451, April 19th, 2023
Excellent services will definitely come back
Customer 452441, September 23rd, 2022
Thanks a lot the paper was excellent
Customer 452453, October 26th, 2022
Customer reviews in total
Current satisfaction rate
3 pages
Average paper length
Customers referred by a friend
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat