Linear regression analysis

Assignment Help Applied Statistics

Reference no: EM133099649

Linear Regression Analysis

Terry Downes owns a commercial cleaning company. He has conducted a survey of customers to determine how satisfied they are with the work performed. He devised a 100-point rating scale-with 0 being poor and 100 being excellent service, selected a random sample of 14 customers, and asked them to rate the service. He also recorded the number of worker hours spent in the customer's facility. These are in the file named Downes.

Use Excel to complete the following:

1. Develop a scatter plot showing the variables, rate of service and worker hours, with the y variable on the vertical axis and the x variable on the horizontal axis, and indicating the type of relationship.

2. Develop a linear regression model to explain the variation in the service rating.
Use Word to complete the following:

3. Describe the model, showing the results of the pertinent hypothesis tests, using a significance level of 0.10.

4. Submit your work in a Word document and attach your Excel file.

5. Institution Release Statement

Attachment:- Linear Regression Analysis.rar

Reference no: EM133099649

Questions Cloud

Calculate net present value and internal rate of return : Calculate net present value, internal rate of return, payback, accounting rate of return. Also, Comment. Calculate target cost and comment

Data sampling and distribution aspects of plan : Explain your choices and strategy for data analysis. Explain the data sampling and distribution aspects of your plan.

Define systems theory : Define Systems Theory and why is studying this theory important to your success as a leader and a manager?

Determine the mark up percentage for product c : Determine the mark up percentage for product C in Alpha Company using Cost-Plus Pricing Method and Absortion Costing

Linear regression analysis : Develop a scatter plot showing the variables, rate of service and worker hours, with the y variable on the vertical axis and the x variable on the horizontal

Develop a flowchart for the proposed statistical inference : Propose the statistical inference to use to solve the problem and Develop a flowchart for the proposed statistical inference, including specific steps

Prepare the journal entries for Headland : The installation process does not involve changes in the windows, so this service can be performed by other vendors. Prepare the journal entries for Headland

Components of the physical presentation : Assess the components of the physical presentation that align with the criteria that makes a highly effective persuasive presentation

Traditional sources of capital : What are the benefits offered by incubator investor firms over other traditional sources of capital?

User Account

All Pages