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

In this section of the marketing and communication plan, you

In this section of the marketing and communication plan, you will develop specific marketing strategies to support the service you are proposing for Bellevue Hospital. In addition, you will explain the communication strategies you will use to involve the internal and external stakeholders of the healthcare organization that will be

Assignment Content Review the Case Study: East Chestnut Regional Health

Assignment Content Review the Case Study: East Chestnut Regional Health System document.  Assume you are the Marketing Manager for East Chestnut Regional Health. Upper management has requested you prepare a Current Situation/SWOT Analysis summary for them.  Conduct a Strengths, Weaknesses, Opportunities, and Threats (SWOT) Analysis on the organization, using the

Study the following two cases and give a case brief

 Study the following two cases and give a case brief following the example provided. Rodney W. Fox, doing business as State Fire & Safety Systems, V. MOUNTAIN WEST ELECTRIC, INC. No.  26289. Shaw Constructors, Inc., v. ICF Kaiser Engineers, Inc., and PCS Nitrogen Fertilizer, L.P. et al., No. 02-30183  Grading

Reflection This reflection is comprised of two sections, collectively totaling

Reflection This reflection is comprised of two sections, collectively totaling a minimum of 500 words. Complete your reflection by responding to all prompts. Ratio Analysis Financial statement analysis focuses primarily on isolating information that is useful for making a particular decision. Through ratio analysis, users of financial data can analyze various relationships between

Personal Learning Mission – 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.

Reimbursement White Paper Essay Nursing Assignment Help

Much of what happens in healthcare is about understanding the expectations of the many departments and personnel within the organization. Reimbursement drives the financial operations of healthcare organizations; each department affects the reimbursement process regarding timelines and the amount of money put into and taken out of the system. However,

Calculate the following key ratios for your selected company for the

3. Calculate the following key ratios for your selected company for the past 4 years. Annual reports are accessible via company websites (show all working out): i) Return on Assets (ROA) = (NPAT / Total Assets) Return on Equity (ROE) = (Net Profit After Tax / Ordinary Equity) Debt Ratio

1. Utilize a Christ-centered spiritual process to help clients and

1. Utilize a Christ-centered spiritual process to help clients and their families identify and meet self-care and spiritual needs and bring peace and comfort. 2. (FYI can you please pick either IV therapy, indwelling catheter ,specimen collection, oxygen therapy ,central line dressing, NG tube, . tube feeding or any clinical

APA FORMAT 1-2 PARAGRAPHS REFERENCES In thinking about new and

 APA FORMAT 1-2 PARAGRAPHS  REFERENCES In thinking about new and improved rewards in the workplace please review the information at this site The future of Total Rewards – Willis Towers Watson Then, based on the information select at least 3 important factors that stood out for you and explain how

Nursing Care Models

INSTRUCTIONS 1. Read your text, Finkelman (2016), pp- 111-116. I will attached the pages to read. 2. Observe staff in delivery of nursing care provided. Practice settings may vary depending on availability. 3. Identify the model of nursing care that you observed. Be specific about what you observed, who was

Prompt: In the article “6 Types of Demand Forecasting” by

Prompt: In the article “6 Types of Demand Forecasting” by the Fulfillment Lab https://www.thefulfillmentlab.com/blog/demand-forecasting and Chapter 14 of your textbook (pp. 403-418), the importance of demand forecasting is discussed. According to the article, “Demand forecasting is the process of understanding and predicting customer demand in order to make smart decisions

A 20.0-m-long uniform beam weighing 550 N rests on walls

A 20.0-m-long uniform beam weighing 550 N rests on walls A and B,Find the forces that the walls A and B exert on the beam when the person is standing at a point 1.6 m to the right of B. Express your answers using two significant figures separated by a

A 300 word paragraph needs to be written answering the

 A 300 word paragraph needs to be written answering the prompt question. The assignment must begin with a thesis. You must identify all relevant concepts, terms and discuss positions against and as well as in favor. In the article attached, they talk about the following Economic indicators: GDP, Unemployment, and

Use the 5 key determinants of Diffusion of Innovation to

 Use the 5  key determinants of Diffusion of Innovation to apply to a survey to  assess the interest level of your target market for your innovation.  Using the 5 key determinants of the Diffusion of Innovation (Roger’s, E.  2003), frame the challenges into scales using the attached survey  methodology for

For the final presentation, you will create a 10- to

For the final presentation, you will create a 10- to 12-slide presentation analyzing a real-world scenario when change was needed in an organization. Change refers to the act of replacing something or making it different. Change in organizations is often related to improvement of organizational processes or accepted behaviors. Your