< Back Excel assign 2.docx The ages of a sample of 100 executives are listed. 30...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
< Back Excel assign 2.docx The ages of a sample of 100 executives are listed. 30 50 60 49 61 62 54 42 47 56 51 61 50 51 57 44 41 48 28 32 61 48 42 54 38 47 49 42 36 48 49 51 36 36 64 45 54 57 41 51 40 39 42 60 45 52 54 48 55 46 60 47 56 42 62 51 52 51 59 63 67 36 54 35 59 47 53 42 65 63 63 74 27 48 32 54 33 43 56 47 59 53 43 82 40 43 68 41 39 37 63 44 54 54 49 52 40 49 49 55 Find the following using this data set: 1. Find the mean, median, mode, sample standard deviation, and population standard deviation using the following functions in Excel. average(); -median(); -mode(); stdev.s(); =stdev.p() 2. Find the 5 number summary using the quartile function in Excel. -Quartile.inc(highlight data set, number either 0, 1, 2, 3, 4) 10 points 10 points 13 < Back Excel assign 2.docx The ages of a sample of 100 executives are listed. 30 50 60 49 61 62 54 42 47 56 51 61 50 51 57 44 41 48 28 32 61 48 42 54 38 47 49 42 36 48 49 51 36 36 64 45 54 57 41 51 40 39 42 60 45 52 54 48 55 46 60 47 56 42 62 51 52 51 59 63 67 36 54 35 59 47 53 42 65 63 63 74 27 48 32 54 33 43 56 47 59 53 43 82 40 43 68 41 39 37 63 44 54 54 49 52 40 49 49 55 Find the following using this data set: 1. Find the mean, median, mode, sample standard deviation, and population standard deviation using the following functions in Excel. average(); -median(); -mode(); stdev.s(); =stdev.p() 2. Find the 5 number summary using the quartile function in Excel. -Quartile.inc(highlight data set, number either 0, 1, 2, 3, 4) 10 points 10 points 13
Expert Answer:
Posted Date:
Students also viewed these mathematics questions
-
Given that log (2) 0.91 and log (5) 2.1, evaluate each of the following. Hint: use the properties of logarithms to rewrite the given logarithm in terms of the the logarithms of 2 and 5. a) log(0.4)~...
-
Refer to the information in BE312. In BE312, Midshipmen Company borrows $15,000 from Falcon Company on July 1, 2015. Midshipmen repays the amount borrowed and pays interest of 12% (1%/month) on June...
-
Two cars drive on a straight highway. At time t = 0, car 1 passes mile marker 0 traveling due east with a speed of 20.0 m/s. At the same time, car 2 is 1.0 km east of mile marker 0 traveling at 30.0...
-
Marvel, Inc. analyzed its accounts receivable balances at December 31 and arrived at the aged balances listed below, along with the percentage that is estimated to be uncollectible: The company...
-
The following information is available about items that differ between the governmental funds and the government-wide statements. Assume that there are no internal service funds. The schedule of...
-
Service Ontario wants to generate a list of vehicle license plate numbers. The plate numbers must be in the following format: NN-MMM, where NN is between two numbers, and MMM is between two numbers....
-
When discussing a financial report in a roleplay (accountant to director), how would you explain: overall profit/loss, the effect accrual accounting has on this result why depreciate assets what is...
-
Eugene Company has inventory it purchased for $6,000. It sells the inventory to a customer for $10,000, including installation. Installation sold separately costs $1,000 and the inventory sold...
-
A hockey player shoots a 0.25 kg puck toward the net. The force on the puck is 105 N and acts for 0.23 seconds. a. What is the impulse created by the hockey stick? (24.15 N sec) b. What is the change...
-
Based on the article written by Boyle, M. A., Augustine, J. J., Garton, E. M., Sharp, D. S., & Mansfield, H. M. (2022). Incorporating noncontingent reinforcement into functional communication...
-
According to social psychology and the topic of "helping other" Who helps and who gets helped? Discuss the factors of the situation that can alter who helps and who gets help (include culture, mood,...
-
what ways can leadership development programs be structured to ensure continuous growth and adaptability in rapidly changing industries ?
-
Which one of the following would increase per unit production cost and therefore shift the aggregate supply curve to the left? a. An increase in worker productivity and production advances. b. A...
-
Design an experiment to demonstrate that RNA transcripts are synthesized in the nucleus of eukaryotes and are subsequently transported to the cytoplasm.
Study smarter with the SolutionInn App