Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help putting this into an excel spreadsheet a step by step would greatly help. The manager of a company that relies on traveling

image text in transcribed

I need help putting this into an excel spreadsheet a step by step would greatly help.

The manager of a company that relies on traveling salespersons to sell the company's products wants to examine the relationship between sales and the amount of time a salesperson spends with each established customer who regularly orders the company's products. He or she believes that sales can be predicted by the amount of time a salesperson spends with a customer. The manager collects the data on 12 salespersons. Sales ($ thousands) 412 Hours spent with customers 3.2 500 4.6 450 3.9 610 5.3 715 6.1 500 4.2 5.6 610 600 5.3 570 5.1 800 7.1 725 6.5 850 7.8 1. Run regression analysis using excel with the data from the above table. Paste the regression output below and upload the excel file with your submission. 2. What is the regression equation for predicted Sales? 3. What would be the predicted Sales if the salesperson spent 5 hours with the customer

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_2

Step: 3

blur-text-image_3

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

Financial Management Core Concepts

Authors: Raymond M Brooks

2nd edition

132671034, 978-0132671033

More Books

Students also viewed these Finance questions

Question

What does the PME seek to accomplish?

Answered: 1 week ago