School

Coastal Carolina Community College **We aren't endorsed by this school

Course

MAT 152 152

Subject

Statistics

Date

Sep 25, 2023

Type

Other

Pages

4

Uploaded by MinisterSummerLoris22 on coursehero.com

Tutorial #1:
Basics of Microsoft Excel
AGE(YRS)
30
21
24
23
23
35
23.89474
21
29
28
23
20
19
19
26
4.420844
20
19
19
26
27
21
1st case
30
454
5th case
23
72
46
26.5
9
5
Type in column "G" the example dataset.
In row 2 type in the title of the set
AGE (YRS)
In rows 3-21 type in the dataset:
30
21
24
23
23
25
21
29
28
23
20
19
26
20
19
19
26
27
21
In cell
I8
you can compute t
of the cases by typing
=AVERAGE(
highlight the nu
wish to compute
)
In cell
I15
you can compute th
deviation age of the cases by
=STDEV(
highlight the numbe
to compute
)
In cell
I22
you can compute the
subjects' ages by typing
=SUM(
highlight the numbers y
compute
)
In cell
B14
you may verify the sample size
of the dataset by using the count function
by typing
=COUNT(
highlight the
numbers you
wish to compute
)
In cell
C22
you may call any given
observation by simply typing an "equals to"
character and selecting the observation you
wish.
Try this for the first and fifth cases
below.
e.g. if you wanted to call the 2nd
case, your code will look like =G4
In cell
D30
you may verify that there are 5
subjects under the age of 21 by using the
countif function. Type
=COUNTIF(
highlight the numbers you
wish to compute, condition in quotes
)
Use the basic arithmitic symbols (+, -, *,
to compute the following:
1. 3rd case * 3
2. 4th case + 5th case
3. The average of the 1st and 5th cases.
4. The difference between the 1st and la
cases.

Tutorial #2:
Building Graphs for Categorical Data
case #
BEWERY
1 Anchor
2 Anheuser Busch
3 Anheuser Busch
4 Adolph Coors
5 Pabst
6 Adolph Coors
7 Anheuser Busch
8 Anheuser Busch
9 Anheuser Busch
10 Anheuser Busch
11 Anheuser Busch
12 Anheuser Busch
BEWERY
COUNT
13 Anheuser Busch
Adolph Coors
8
Other
28
14 Anheuser Busch
Anheuser Busch
19
Miller
20
15 Anheuser Busch
Boston Beer
4
Anheuser
19
16 G. Heileman
Miller
20
Adolph Coo
8
17 G. Heileman
Pabst
7
Pabst
7
18 Adolph Coors
Other
28
Boston Bee
4
19 Adolph Coors
TOTAL
86
20 High Falls Brewing
21 High Falls Brewing
22 High Falls Brewing
23 High Falls Brewing
24 Adolph Coors
25 Miller
26 Miller
27 Miller
28 Miller
29 Adolph Coors
30 Adolph Coors
31 Adolph Coors
32 Leinenkugel
33 Leinenkugel
34 Leinenkugel
35 Leinenkugel
36 Leinenkugel
37 Leinenkugel
38 Leinenkugel
39 Miller
40 High Falls Brewing
41 Anheuser Busch
42 Anheuser Busch
43 Anheuser Busch
44 Anheuser Busch
45 Anheuser Busch
46 Anheuser Busch
47 Anheuser Busch
48 Miller
49 Miller
50 Miller
51 Miller
52 Miller
53 Miller
54 Miller
55 Miller
56 Miller
57 Anheuser Busch
58 Stroh
59 Stroh
60 Miller
61 Pabst
62 Pabst
63 Red Hook
64 Red Hook
65 Latrobe
66 Boston Beer
67 Boston Beer
68 Boston Beer
69 Boston Beer
70 Pabst
71 Pabst
72 Sierra Nevada
73 Sierra Nevada
74 Sierra Nevada
75 Pabst
DIRECTIONS:
According to an online resource, a focus group identified
Coors, Busch, Boston, Miller, and Pabst as the "most popular
beer brand in the U.S."
Note that the "Other" value is simply
the the bewerys not listed above.
Below, generate (1) a bar graph (in counts) and (2) a pie chart
(in percentages) for the above distribution.
Format using the
APA guidelines discussed in class.
Title your graphs "Most
Popular Beer Brand".
HINT:
For the counts, I
recommend using the
COUNTIF function.
For the "Other" count,
try subtracting the
sample size from the
sum of the above
counts.
APA Guidelines Reminders
Bar Graph
- Values must be ordered in decending order
from left to right on the graph.
You need a title, x-axis
lables, y-axis lables.
Y-axis must start at zero.
Pie Chart
- Sectors must be ordered in decending order of
size clockwise starting at 12 O'clock.
You need a legend,
title and percentage labels for each sector.
Other
Miller
Anheuser
Busch
Adolp
h C
oors
Pabst
Boston
Beer
0
5
10
15
20
25
30
Most Popular Beer Brands
Brewery
Count
32.56%
23.26%
22.09%
9.30%
8.14%
4.65%
Most Popular Beer Brand
Other
Miller
Anheuser Busch
Adolph Coors
Pabst
Boston Beer

76 Pabst
77 Miller
78 Miller
79 Miller
80 Miller
81 Miller
82 D. G. Yuengling
83 D. G. Yuengling
84 D. G. Yuengling
85 D. G. Yuengling
86 D. G. Yuengling

Tutorial #3:
Building a Histogram for Quantitative Data
case #
CO2
1
2.3
6.5850833905617
2
3.9
3
17.0
4
0.2
5
1.8
6
16.0
7
2.5
8
1.4
9
0.0
10
1.7
11
0.0
12
6.1
13
10.0
14
0.2
15
0.9
16
1.2
17
7.3
18
3.8
19
3.6
20
9.1
21
0.3
22
9.7
23
8.8
24
4.6
25
3.7
26
1.0
27
0.2
28
0.1
29
0.3
30
0.7
31
0.8
32
0.9
33
8.0
34
3.9
35
10.2
36
11.0
37
8.1
38
6.8
39
0.2
40
0.1
41
2.5
42
2.8
43
9.0
44
19.9
45
7.6
46
4.8
47
5.1
48
0.5
Directions: Build a histogram using the CO2 data set provided.
The units of the values
are "parts per million (ppm)"
Use the below worksheet to set up and then create a
histogram for the CO_2 levels (units are ppm).
Title the
histogram "Emissions by Product".
Reminder: Use Sturge's rule to determine the number of
needed bins.
APA Guidelines Reminders
You need a title, x-axis lables (w. units), y-axis lables.
Y-axis
must start at zero.
There should be no gaps in the bars.
This chart isn't available in your version of Excel.
Editing this shape or saving this workbook into a different file format will
permanently break the chart.