Linear Regression Analysis Terry Downes owns a commercial cleaning company.

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

Read the text and view the images in the Immigrants

Read the text and view the images in the Immigrants Mean Business digital exhibit. Post your thoughts on these questions (300-500 words). Support your response by giving specific examples from at least three of the businesspeople highlighted. What are some of the personal and community challenges these immigrant entrepreneurs face

Evaluate the Health History and Medical Information for Mr. C., presented below. Based on this information, formulate a conclusion based on your evaluation, and complete the Critical Thinking Essay as Nursing Assignment Help

Evaluate the Health History and Medical Information for Mr. C., presented below. Based on this information, formulate a conclusion based on your evaluation, and complete the Critical Thinking Essay assignment, as instructed below. Health History and Medical Information Health History Mr. C., a 32-year-old single male, is seeking information at

Define The 5 E’s Of Public Admin

 Description Topic: Define the 5 E’s utilizing sources other than the definitions provided on the website or from a dictionary including those online. Analyze if each of the E’s is inclusive with one-another or if they are mutually exclusive. Cite examples and give sources for your answers. Book: The Effective

The concept of libel is an important one given today’s

 The concept of libel is an important one given today’s use of social media and digital communication. Everyone has the opportunity to post their opinion, but is it possible to go too far? For this assignment, imagine you are asked by your employer to create a tip sheet explaining libel

1. Submit a copy of your Exercise Prescription/Plan that you

Premium Paper Help is a professional writing service that provides original papers. Our products include academic papers of varying complexity and other personalized services, along with research materials for assistance purposes only. All the materials from our website should be used with proper references.

Photography Assignment For this assignment, you will apply the concepts

Photography AssignmentFor this assignment, you will apply the concepts of photography that you learned in this unit. You will compare and contrast two photographs from the chapter on photography to two photographs from your life. This means you will analyze four photographs total. For example, the photographs from your life

WGSS 1104: Feminisms in the Arts

 write a 2-page (double spaced) response to it. If citing specific images, pieces, or quotes, include them in a bibliography section using MLA formatting. Find and analyze a piece of writing that you feel exemplifies Virginia Woolf’s concept of “androgynous thinking”. This does not have to be a full text

I need this asap please Nursing Assignment Help

For this coding assignment code the chart below by entering your codes on the Outpatient Coding Worksheet. Sean Tillerman Submit your completed assignment by following the directions linked below. Please check the Course Calendar for specific due dates. Save your assignment as a Microsoft Word document. Mac users, please remember to append the

Types of nutrition – Premium Paper Help

Premium Paper Help is a professional writing service that provides original papers. Our products include academic papers of varying complexity and other personalized services, along with research materials for assistance purposes only. All the materials from our website should be used with proper references.

Final Research Proposal The final draft of your Research Proposal

Final Research Proposal  The final draft of your Research Proposal is due at the end of this module.  One member from each group should submit the final research proposal that covers the following: Format for a Qualitative Proposal Qualitative constructivist format Introduction Statement of the problem Purpose of the study

So far, we have discussed the ways that scientific findings

So far, we have discussed the ways that scientific findings can complement Scripture, check our interpretation of Scripture, and provide reliable frameworks for understanding much of the world around us. However, some argue that science has limitations, particularly in the areas of ethics and morality. For example, science can tell

An Examination of the Moderating Effects of the High School

An Examination of the Moderating Effects of the High School Socioeconomic Context on College Enrollment   Drawing on a nationally representative sample of high school seniors from the Educational Longitudinal Survey of 2002 (ELS), this study examines the influence of the high school socioeconomic context on students’ decisions to attend

Data Analysis Processes

Post an explanation for your choice of data analysis technique for doctoral qualitative research. In your explanation, do the following: • Briefly describe the business problem identified for your DBA Doctoral Prospectus. • Explain which data analysis process is most appropriate to your DBA Doctoral Study, providing a rationale for

1. Evaluate the integral ∫x5(x^6−10)^47dx by making the substitution u=x^6−10.

1.  Evaluate the integral∫x5(x^6−10)^47dxby making the substitution u=x^6−10. =_+C 2. Evaluate the indefinite integral. ∫7dx/xln(8x) =_  + C 3.  Evaluate the indefinite integral. ∫x^8e^x^9dx =_+C 4.  Evaluate the indefinite integral. ∫x4(15+x^5)^1/2dx=_+C 5.  Evaluate the indefinite integral. ∫4/(t+5)^8 dt =_+C 6.  Evaluate the indefinite integral:  ∫x/x^2+4 dx =_+C 7.   A cell

You have been asked to teach a new patient nutrition

You have been asked to teach a new patient nutrition class. In the first class session, you plan to present information using PowerPoint. As you prepare this presentation, choose your audience and state whether the patients are mothers with young children, adults, or seniors. Then include the following information on

Hello class, please post some of your reactions, critical ideas,

  Hello class, please post some of your reactions, critical ideas, and interpretations of “The Story of an Hour” by Kate Chopin. Before engaging in this thread, you should have completed all readings in Module 1 Week 1.  **You will not be able to view your classmates’ responses until after

Apply what you have learned about Health Promotion and Disease

Apply what you have learned about Health Promotion and Disease Prevention, and demonstrate the ability to develop a holistic plan of care, incorporating Telehealth and defining assessment and intervention of specific population incorporating unique attributes of populations for health promotion, wellness preservation, and maintenance of function across the health-illness continuum.