ITEC 610 - 023
Applied Managerial Statistics
Describing Data Assignment
Spring 2017
Show all work.
Unsubstantiated answers receive no credit.
Be sure to attach all output from Excel.
(15 points) Describing Data
Educators are constantly evaluating the efficacy of public schools in the education and training of
American students. The SAT scores of 30 randomly chosen students are given below.
464
483
773
491
488 463
488
590
460
600 448
502
460
448
769 545
504
567
500
773 422
557
602
712
540 502
602
579
737
443 a. (4 points) Using Excel find the mean, median, mode, range, variance and standard deviation of
the data. Attach your output from Excel.
b. (5 points) Using Excel, construct a frequency histogram of the data set. Use the guidelines in the
class notes. Start the first interval 0.5 below the minimum value in the data set. Provide all the
details (interval, width, etc.) on how you constructed the histogram. Make sure that you attach
the histogram created by Excel. Comment on the shape of the frequency distribution (e.g., is the
distribution skewed? Is the distribution approximately mound-shaped and symmetric?) for the
data set based on your histogram.
c. (4 points) Based on the results in part a, construct the intervals x s, x 2 s and x 3s for the data set. Be sure to show your interval below. Based on the results in part b, what percentage of
measurements for the data set do you expect to fall in each interval? What percentage of the
measurements for the data set actually falls in each interval?
d. (1 point) What would be the more appropriate measure of central tendency for these data,
mean or median? Why?
e. (1 point) Find an interval that is likely to contain the SAT scores. Interpret your interval.

• 1503478698-Stat Help Needed.docx

AccountingQueen

(3)

Status NEW Posted 23 Aug 2017 08:08 AM My Price 10.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k y-----------ou -----------for----------- us-----------ing----------- ou-----------r w-----------ebs-----------ite----------- an-----------d a-----------cqu-----------isi-----------tio-----------n o-----------f m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l

Not Rated(0)

• Buy Answer