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

Requirement for discussion board: Response and respond to at least

 Requirement for discussion board:  Response and respond to at least one other post, offering one or two paragraphs of additional insight and details. This could be additional support for their point of view, or it could be arguing a counterpoint.  Discussion Board of other student is below: # – Is

To complete my project, I must consider the pros and

To complete my project, I must consider the pros and cons of enjoying Happy Wheels. Can somebody assist me? This is unlike any other online racing game you’ve ever played. Join forces with some of the world’s most daring racers, daredevils, cyclists, and stuntmen and women. In Happy Wheels, they

Unit 4 Assignment: Case Study 2 Attached Files: CIS250 Unit

  Unit 4 Assignment: Case Study 2 Attached Files: Due: Sunday by 11:59 pm ESTIn this case study, you have been provided with a spreadsheet with a large amount of sales data for a company. The data is not well organized. You have been tasked with figuring out the answers

During the world wars of the twentieth century, Russia gained

  During the world wars of the twentieth century, Russia gained a reputation for being absolutely ruthless towards its own people.   Russian soldiers would routinely burn villages and crops and shoot livestock in order to leave nothing for enemy soldiers to live on – but this left their own civilians

 Locate one peer reviewed evidence-based article that describes a “best practice” being used in delivering client centered care and promoting health. It can be for any client across the life span. Dis Nursing Assignment Help

 Locate one peer reviewed evidence-based article that describes a “best practice” being used in delivering client centered care and promoting health. It can be for any client across the life span. Discuss the best practice and give two reasons why this practice is important and “best” and how it affects

As future clinicians, it is important to have a good

As future clinicians, it is important to have a good understanding of autism spectrum disorder symptoms, best practices for treatments, and to be aware of the common forms of misinformation about the disorder. Create an 8-12-slide PowerPoint presentation about autism spectrum disorders. Include or address the following in your presentation:

OOH – Billboards — CEVMS

Answer these questions by number: 1. In terms of “any billboard” – not just digital billboards – are they “sky trash” as Scenic America suggests, or do they provide a value to consumers and advertisers as the Outdoor Advertising Association of America asserts? (Be sure to download and peruse the

Q1: What is the ratio of the radius of a

 Q1: What is the ratio of the radius of a circle to its circumference?Q2: Divide 360$ among A, B and C in such a way that As share is twice that of B, and Bs share is twice that of C.Q3: The ratio of two digits is 1:3. What is

American Court System

You should include the following in your discussion: a comparison of the sentencing and court structures of the American court system, a description and a comparison of indeterminate and structured sentencing, a description of the four sentencing options currently employed within the American sentencing structure, and provide examples where each

There is debate among developmental theorists as to what influences

 There is debate among developmental theorists as to what influences thoughts and behavior related to gender. For example, what influences a child to play with a doll versus a truck, or what influences a child to engage in active play versus passive play? Is gender identity more heavily influenced by

utilitarianism and deontology

There are three parts to the paper. First, explain the basic principles of utilitarianism and deontology. Second, present an example where you ask a clear ethical question and then apply utilitarianism and deontology to reach different answers. Third, explain which theory offers a better approach to ethical decision-making and defend

A New Marketing Opportunity The CEO of your firm has

 A New Marketing Opportunity The CEO of your firm has just announced that the organization is considering two diverse strategies to increase business: marketing healthcare services to the mature healthcare consumer, or marketing healthcare services to international consumers.  Read the following two articles:  Fell, D. (2002). Taking the U.S. health

Jose is a 55-year-old Hispanic, male, migrant worker who speaks

  Jose is a 55-year-old Hispanic, male, migrant worker who speaks limited English. He presented to the emergency room with complaints of edema of the scrotum, urinary retention, and hematuria. He does not have any pertinent past medical history. He is married and has five young children. He states he

A new medium-sized health care facility just opened and you

 A new medium-sized health care facility just opened and you are hired as the CIO. The CEO is somewhat technical and has tasked you with creating a threat model. The CEO needs to decide from 3 selected models but needs your recommendation. Review this week’s readings, conduct your own research,

The impacts of climate change in time and space go

The impacts of climate change in time and space go beyond our imagination. It is easy to feel like we, as individuals, have little power to make a difference. However, it is possible for individuals and communities to make decisions that reduce our impacts on Earth. Watch the following videos

Minimum of 300 words with at least two peer review reference in 6th edition apa style. It is important for APRNs to know what medication errors occur and the cause of these errors in order to reduce t Nursing Assignment Help

Minimum of 300 words with at least two peer review reference in 6th edition apa style. It is important for APRNs to know what medication errors occur and the cause of these errors in order to reduce them. Review research studies performed within the last 3-5 years regarding medication errors.

6-7 Slide power point presentation with detailed speaker notes. Sources

6-7 Slide power point presentation with detailed speaker notes. Sources cited in APA format.  Overview  As part of the contingency planning for your organization’s exit strategy, you have researched and analyzed a potential alternative buyer. As the possibility increases that the original buyer will withdraw from the deal, your VP