Question: Write down excel command Question 4 The weights (in pounds) of 30 newborn babies are listed below. 5.5 5.7 5.8 5.8 6.1 6.1 6.4 6.4

Write down excel command

Write down excel command Question 4 The weights (in pounds) of 30

Question 4 The weights (in pounds) of 30 newborn babies are listed below. 5.5 5.7 5.8 5.8 6.1 6.1 6.4 6.4 6.5 6.6 6.7 6.7 6.7 6.9 6.9 7.0 7.0 7.1 7.2 7.2 7.4 7.5 7.7 7.7 7.9 8.0 8.1 8.1 8.3 8.7 Find the percentile of 7.1 pounds. The value 7.1 pounds corresponds to th percentile. Write down the EXCEL Command used for your work on your paper for full credit and upload later. Question 5 The following table presents the number of years of five employees in a company has been employed (x) and their hourly wage in dollars (y). x (years) 0.5 1.0 1.75 2.5 3.0 y (dollar) 9.23 12.16 10.36 19.63 28.42 Round to two decimal places if necessary. Compute the following: a) linear correlation coefficient r = b) The least-square regression line is y = c) Based on part b): If an employee worked for 2.75 years in a company, the person is expected to earn $ per hour. Take screenshot of your EXCEL work on your paper for full credit and upload later

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!