Question

In: Math

The following data shows the hours worked by employees at a McDonalds and the number of...

The following data shows the hours worked by employees at a McDonalds and the number of dollars that they earned that day. Hours worked Pay dollars 8 68 7 59.5 8 68 5 42.5 10 85 8.5 72.25 7.5 63.75 9 76.5 Average: 7.875 66.9375 Standard Deviation 1.482035 12.5973 Correlation 1 a)Draw a scatterplot that represents this data. Draw an estimate for the line of least fit on the scatterplot as well. b) Use technology to find the least squares regression line. Write the equation below. c) Use the equation from the previous question to find how much a person would be paid for a 12 hour shift. Show your work.

Solutions

Expert Solution

a) We can use excel to draw the scatter plot :

Select both data set ---> Go to Insert menu ---> Charts ---> Scatter plot.

b)

Lease square regression equation.

Y = b0 + b1 *x

Or Pay dollars = b0 + b1 * Hours

b0 is Intercept , we can find intercept using excel function =INTERCEPT( Y data set column range, x data set column range )

b1 is Slope , we can find slope using excel function =SLOPE( Y data set column range, x data set column range )

Least squares regression line :

Pay dollars = 8.5*hours

c) We are given hours = 12 and asked to predict Pay dollars using above equation of regression line

Pay dollars = 8.5*12

Pay dollars = 102

So  a person would be paid 102 dollars for a 12 hour shift.


Related Solutions

The number of hours worked by 24 employees of a company is given below: 40 43...
The number of hours worked by 24 employees of a company is given below: 40 43 40 39 36 44 40 39 39 52 27 50 41 47 40 48 38 36 25 41 35 36 16 40 (a) (6 points) Calculate the mean, variance and standard derivation for the given data (b) (6 points) Calculate the three quartiles (Q1, Q2, and Q3) and the Interquartile range (IQR) (c) (4 points) Calculate the values of the lower fence and the...
1) A random sample of the number of hours worked by 40 employees has a mean...
1) A random sample of the number of hours worked by 40 employees has a mean of 29.6 hours worked. Assume the population standard deviation is 7.9 hours. a. Using a 95% confidence level, find the margin of error, E, for the mean number of hours worked. 2) In a study of 265 subjects, the average score on the examination was 63.8. Assume σ = 3.08. a. What is a 95% confidence interval for ? 3) A college admissions director...
(a) The following data shows the number of hours that 8 hospital patients slept following the...
(a) The following data shows the number of hours that 8 hospital patients slept following the administration of a certain anesthetic. 8, 5, 12, 10, 11, 4, 6, 10, Find a 95% confidence interval for the average hours slept following the administration of the anesthetic for the sampled population.
On Excel data shows hours of experience and the corresponding quality scores for employees at a...
On Excel data shows hours of experience and the corresponding quality scores for employees at a plant. The company is interested in studying the relationship between hours of experience and quality scores. a)Compute the correlation coefficient between hours of experience and quality scores. Use Excel’s CORREL function. b)Construct a scatter plot of quality scores vs. hours of experience. Does there appear to be a relationship? What kind? c)Obtain a regression output that could be used to predict quality scores based...
the following table shows the distribution of hours worked each week on average for a sample...
the following table shows the distribution of hours worked each week on average for a sample of 100 community college students. hours per week number of students 0-9 24 10-19. 14 20-29. 39 30-39. 18 40-49. 5 1) what is mean? round 3 decimals 2) standard deviation of sample? round 3 decimals 3) what is the mid point of the class 20-29? 4) do a histograms of the data ; shape of distribution? 5) what is quartile 75 of distribution?
The following frequency table summarizes the number of hours worked by a sample of 120 students...
The following frequency table summarizes the number of hours worked by a sample of 120 students in the same week. Hours worked by students Class (hours) Frequency (0, 10] 10 (10, 20] 60 (20, 30] 40 30 or more 10 Total 120 Show/hide advanced buttonsParagraph stylesBoldItalicUnordered listOrdered listLinkUnlinkInsert or edit imageInsert or edit an audio/video fileRecord audioRecord videoManage files A) How many students worked more than 10 hours but less than or equal to 30 hours? B) What is the...
The following table shows the weights​ (in pounds) and the number of hours slept in a...
The following table shows the weights​ (in pounds) and the number of hours slept in a day by a random sample of infants. Test the claim that Mnot equals≠0. Use alphaαequals=0.10.1. Then interpret the results in the context of the problem. If​ convenient, use technology to solve the problem.    ​Weight, x 8.28.2 10.110.1 9.99.9 7.17.1 6.96.9 11.111.1 10.910.9 15.115.1 Hours​ slept, y 14.814.8 14.714.7 14.114.1 14.214.2 13.913.9 13.213.2 13.813.8 12.412.4 1. Identify the null and alternative hypotheses. 2. Calculate the...
The table to the right lists the average number of hours worked in a week and...
The table to the right lists the average number of hours worked in a week and the average weekly earnings for U.S. production workers from 1967 to 1996. (The World Almanac 1998) 1) Construct a scatter diagram and comment on the relationship, if any, between the variables Weekly Hours and Weekly Earnings. 2) Determine and interpret the correlation for hours worked and earnings. Based upon the value of the correlation, is your answer to the previous question reasonable? 3) Based...
The following information shows the number of hours students studied for classwork and the score they...
The following information shows the number of hours students studied for classwork and the score they got on the classwork. Show your work to receive credit. Hours Studied x 8 4 9 6 3 2 11 7 Score y 72 64 81 59 43 47 89 70 a) Compute the value of the correlation coefficient r.                         b) Find the equation of the regression line.
The number of hours that should be worked by a full-time bar attendant is stipulated in...
The number of hours that should be worked by a full-time bar attendant is stipulated in the Queensland award as 36.25 hours per week. However, the secretary of the Queensland Council of Unions believes that the average work hours per week of full-time bar attendants is not that specified in the award. From a random sample of 38 workers, it was found that the average working week was 36.65 hours with a variance of 0.85 hours squared. On the basis...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT