Develop a scatter plot showing the variables

Reference no: EM133474158

Case: 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 Download Downes.

Use Excel to complete the following:

Question 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.

Question 2: Develop a linear regression model to explain the variation in the service rating.

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

Reference no: EM133474158

Questions Cloud

Different techniques to analyze total project risk : Compare and contrast the different techniques to analyze total project risk and What are the strengths and weaknesses of each technique

Identify three legal but ethically unacceptable activities : Identify three legal but ethically unacceptable activities that are conducted on the Internet in general (may or may not be on the Deep Web)

How much protein should these athletes be eating : When it comes to powerlifters and strength training athletes who pump iron all year round, how much protein should these athletes be eating?

Prevent cross-border infiltration of terrorist : What are some of the methods used to prevent cross-border infiltration of terrorists into the United States?

Develop a scatter plot showing the variables : 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 an investigation plan for the frauds indicated : Develop an investigation plan for the frauds indicated in the scenario. There should be a separate investigation plan for each of the three frauds

Explain effective communication of the healthcare : Why you think the qualities and principles outlined in The Essential and Effective Communication of the Healthcare Administration Supervisor.

Effective crime control requires focus on communities : A strong consensus has emerged among criminologists that effective crime control requires a focus on communities.

What conclusions can you draw : Complete a vertical analysis that will compare accounts receivable and inventory to total assets for each year. What conclusions can you draw

User Account

All Pages