Linear Regression AnalysisTerry Downes owns a commercial cleaning company. He

Linear Regression AnalysisTerry 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 16 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.xls
 

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.
  2. Develop a linear regression model to explain the variation in the service rating using a significant level alpha = 0.10
  3. Estimate the regression equation for the model.

Use Word to complete a short report to include the following: 

  1. The scatter plot describing the relationship of the variables and the estimated linear regression equation.
  2. The null and alternative hypotheses at the significant level alpha = 0.10
  3. The regression analysis showing the results of the pertinent hypothesis test, using a significance level of 0.10.
  4. The analysis of the linear regression indicating if the model is significant based on the p-value, e.g., rejecting or failing to reject the null hypothesis.
  5. The significance of the R2 (Coefficient of determination) in the model.

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

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Review the Wk 2 – Apply: Statistical Report assignment. In

Review the Wk 2 – Apply: Statistical Report assignment.  In preparation for writing your report to senior management next week, conduct the following descriptive statistics analyses with Microsoft® Excel®. Answer the questions below in your Microsoft® Excel® sheet or in a separate Microsoft® Word document: Insert a new column in

Hello MKT455 Class, Read the brief HBR case study, Target

  Hello MKT455 Class, Read the brief HBR case study, Target the Right Market. You can find the case study at this website…it is very short: https://hbr.org/2012/07/target-the-right-market (Links to an external site.) Read the case study carefully and answer this question: QUESTION: Should SparkPlace target small Sams or medium Marys? DO

Students will maintain a journal of Academic Practice. This Journal

  Students will maintain a journal of Academic Practice. This Journal will be a collection  of insights from, readings, group discussions, videos, and other material accessed for the  course. The journal must maintain a balance between the theories/concepts of management,  and application to one’s life and work. Length: 1-2 pages per

Reflection and Discussion Forum Week 3 Reflection and Discussion Forum

  Reflection and Discussion Forum Week 3 Reflection and Discussion Forum Week 3Assigned Readings:Chapter 6. Products: Goods and Services.Chapter 7. Brands.Chapter 8. New Products and Innovation.Initial Postings: Read and reflect on the assigned readings for the week. Then post what you thought was the most important concept(s), method(s), term(s), and/or

Accounts are crucial subjects that very commerce student has to

Accounts are crucial subjects that very commerce student has to work hard on scoring. If the balance sheet gets tallied, certainly accounting was rightly done. But accounting subject is not just limited to tallying the balance sheet. More concepts have been introduced with new software. That is why students need

Develop an informative 5-10 min speech. 4 pieces of information

Develop an informative 5-10 min speech.  4 pieces of information required. 1.) Discuss the Diagnostic Criteria; What does this disorder look like? What does this disorder look like? What are the symptoms? 2.) Prevalence; Explain how common this disorder is. What are the statistics? (Ex. % of population diagnosed with

You are working as the manager of a multispecialty clinic.

  You are working as the manager of a multispecialty clinic. You have been notified that a patient has filed a lawsuit against one of your physicians that has terminated a relationship with a patient. Executive management has asked you to prepare a memo to describe whether a patient can

Evaluation of GRAND theories in nursing

Instructions Topic: Evaluation of GRAND theories in nursing 4 Peer review articles APA 6th edition Theory Analysis Use the following questions as SUBHEADINGS; ● Are concepts theoretically and operationally defined? Describe. ● Are statements theoretically and operationally defined? Describe. ● Is there a model/diagram? Does the model contribute to clarifying

Cancer is one of the leading causes of death in

Cancer is one of the leading causes of death in both men and women. Caring for the cancer patient and family requires a multidimensional approach. What does it mean to provide a multidimensional approach? What are some examples of how the care team can meet the patient and the family’s

The following exercise introduces you to supply chain management strategies

 The following exercise introduces you to supply chain management strategies and collaboration in a team setting. Complete the exercise, Interactive Analysis: Creating Value Through Operations. A transcript of this interactive exercise is also available. Consider what you learned in the experience and respond to the following in a minimum of

Software test plans identify specific features that need to be

  Software test plans identify specific features that need to be tested, how they need to be tested, and to what extent they need to pass the identified tests. Respond to the following in a minimum of 175 words: What are the ramifications of stringent testing criteria vs. lax testing

Maternity Abortion in The State of Florida Research Paper Nursing Assignment Help

Topic: Abortion Title page (APA format) Define Abortion. What is the law regarding abortion on the State of Florida. What are your personal thoughts regarding Abortion? Conclusion Expert Solution Preview Introduction: Abortion is a controversial topic that has been debated for many years, with opposing perspectives and beliefs on the

Chapter 7 Questions Define the concept of a Database. What

Chapter 7 Questions Define the concept of a Database.  What are the advantages of using databases? List and explain the security requirements of databases?   Define and explain  the terms Data Suppression and Data Concealing. Define the terms Data Mining and Big Data. Chapter 8 Questions List the 5 determining characteristics

This week you will submit your presentation based on your

This week you will submit your presentation based on your report or proposal. It will consist of five to six visually appealing slides, accompanied by an audio recording of approximately 5 minutes in total (or about 1 minute per slide). The basic slide structure should be as follows. Title slide,

Let’s begin with the Archipelago of Hawaii. How come this

Let’s begin with the Archipelago of Hawaii. How come this archipelago exists in the Pacific Ocean? Why was not created in the Atlantic Ocean? How many islands does this archipelago have? Why that many? What lives on these islands and why? How old are these islands? How old are its inhabitants?

Case Study, Chapter 41, Disorders of Endocrine Control of Growth and Metabolism Bertha is a 71-year-old woman who takes daily medication for Hashimoto thyroiditis. Last winter, she developed pneumon Nursing Assignment Help

Case Study, Chapter 41, Disorders of Endocrine Control of Growth and Metabolism Bertha is a 71-year-old woman who takes daily medication for Hashimoto thyroiditis. Last winter, she developed pneumonia. Although she did her best to run errands for her husband, she got tired easily and needed to rest frequently. One