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

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
Get step-by-step solutions from verified subject matter experts
