Question

1. Utilize the below data to develop a Histogram using Excel. Part A) Copy your Excel Histogram below in this Word document, and then answer the questions in Part B).

            Data:

Student	Exam Score
a	60
b	70
c	80
d	90
e	65
f	75
g	85
h	99
i	55
j	40
k	50
l	60

Use the below bin range for your histogram:

Bin Range

0-60

60.1-70

70.1-80

80.1-90

90.1-100

Note: Remember that for a histogram, the bars need to touch (no spaces between the bars).

Part A) Insert Histogram below:

Part B) Is your data normally distributed?

Answer 1

Soln

Steps

• Create 5 Intervals as given and count the frequency for each bin
• Plot a histogram as shown below

Bin	Freq
0-60	5
60.1-70	2
70.1-80	2
80.1-90	2
90.1-100	1
Total	12

The data is not normally distributed as from the above histogram we can conclude that the data is skewed to the right (Right tail is longer than left tail)