Lab #$1$: Frequency Table and Histogram

Objective: Use the built$-$in functions of Excel to create a Frequency Table and Histogram as we did in class. Note this is more complex than creating a regular graph in Excel, but we will be able to create the same graph as we did in the lessons.

Step #$1$: Let$$s get started

Download the Starter file in Blackboard in the Labs folder.

Step #$2$: Create Frequency Table and Histogram

$1.$ In cell A$1$ type Lab #$1$: Frequency Tables and Histograms. In cell A$3$ type A: Amusement Park Spending $($$$).$SLab #$1$: Frequency Table and Histogram

Objective: Use the built$-$in functions of Excel to create a Frequency Table and

Histogram as we did in class. Note this is more complex than creating a regular

graph in Excel, but we will be able to create the same graph as we did in the

lessons.

Step #$1$: Let's get startedSs

Download the Starter file in Blackboard in the Labs folder.

Step #$2$: Create Frequency Table and Histogram

In cell A$1$ type Lab #$1$: Frequency Tables and Histograms. In cell A$3$ type A:

Amusement Park Spending $($$$).$

Define the classes for the frequency table using the methods in class $($do

this on paper$).$ Excel can then create a frequency table and histogram for

us using the data and the upper class limits that we provide. We will input

the heading title Upper Class Limits in cell D$7$ followed by entering the

actual upper class limits we determined in our class notes in cells D$8$

through D$15($assuming $8$ classes$).$

Create the frequency table and histogram for Data set A$.$

a$)$ Choose the "Data" tab at the top of the screen

b$)$ Click "Data Analysis". If this option is not available, click the "File" tab,

then "Options". Choose "Add$-$ins" from the menu on the left side, then

click $"$Go$"$ at the bottom. Select "Analysis Tool Pack" and click $"$OK$".$

c$)$ Select "Histogram" and click $"$OK$"$

d$)$ Go to "Input Range" and click on the arrow icon to the right, highlight

the data you were given, then click on the same icon.

e$)$ Go to "Bin Range" and click on the arrow button to the right. Use the

mouse to highlight cell D$8$ through D$15$ and click the arrow button again.