Question: Statistics with excel with frequency chart, how do i use excel to find the means, median etc? please list the steps on excel 1. A
Statistics with excel with frequency chart, how do i use excel to find the means, median etc? please list the steps on excel

1. A random sample of 1000 last names (surnames) is drawn from a student database at a local college. The distribution of the lengths of the names is as shown in the table below. Number of letters in last name 3 4 5 6 8 9 10 11 12 Frequency 13 102 186 237 215 113 83 32 13 6 allowed). You must perform the following calculations entirely using Microsoft Excel (no calculators Calculate the mean the median the (sample) standard deviation the range
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
