4. The worksheet will also show the average number of orders fulfilled for each column in the section above. In cell B12, create a nested formula using the AVERAGE and ROUND functions to first find the average number of boxed sets sold in January (the range B6:B9), and then round the answer to 0 digits. Copy the formula from cell B12 to the range C12:N12.

Jayne is studying urban planning and finds that her town is decreasing in population by 3% each year. the population of her town is changing by a constant rate. true or false?

Jubal wrote the four equations below. he examined them, without solving them, to determine which equation has no solution. which of jubal’s equations has no solution hurry

Jobs and productivity! how do retail stores rate? one way to answer this question is to examine annual profits per employee. the following data give annual profits per employee (in units of 1 thousand dollars per employee) for companies in retail sales. assume σ ≈ 4.0 thousand dollars. 3.7 6.7 3.6 8.5 7.5 5.9 8.7 6.4 2.6 2.9 8.1 −1.9 11.9 8.2 6.4 4.7 5.5 4.8 3.0 4.3 −6.0 1.5 2.9 4.8 −1.7 9.4 5.5 5.8 4.7 6.2 15.0 4.1 3.7 5.1 4.2 (a) use a calculator or appropriate computer software to find x for the preceding data. (round your answer to two decimal places.) thousand dollars per employee (b) let us say that the preceding data are representative of the entire sector of retail sales companies. find an 80% confidence interval for μ, the average annual profit per employee for retail sales. (round your answers to two decimal places.) lower limit -- thousand dollars upper limit -- thousand dollars (c) let us say that you are the manager of a retail store with a large number of employees. suppose the annual profits are less than 3 thousand dollars per employee. do you think this might be low compared with other retail stores? explain by referring to the confidence interval you computed in part (b). yes. this confidence interval suggests that the profits per employee are less than those of other retail stores. no. this confidence interval suggests that the profits per employee do not differ from those of other retail stores. correct: your answer is correct. (d) suppose the annual profits are more than 6.5 thousand dollars per employee. as store manager, would you feel somewhat better? explain by referring to the confidence interval you computed in part (b). yes. this confidence interval suggests that the profits per employee are greater than those of other retail stores. no. this confidence interval suggests that the profits per employee do not differ from those of other retail stores. (e) find an 95% confidence interval for μ, the average annual profit per employee for retail sales. (round your answers to two decimal places.) lower limit 3.75 incorrect: your answer is incorrect. thousand dollars upper limit 6.41 incorrect: your answer is incorrect. thousand dollars