Topic_5_DQ_2
.xlsx
keyboard_arrow_up
School
Grand Canyon University *
*We aren’t endorsed by this school
Course
144
Subject
Mathematics
Date
May 28, 2024
Type
xlsx
Pages
10
Uploaded by kns2711
Excel Skills Learned
Upon completing the sheet, you should have an understanding of:
Math Skills Learned
1. How to create a frequency and relative frequency table.
2. How to visualize a frequency distribution via a histogram.
3. Start thinking about how to draw conclusions from data. Instructions
: Open
complete the tasks
name where indica
sheet is not curren
1. Use of the =COUNTIFS() (or =FREQUENCY()) functions as functions that operate on a range of values.
2. Adding and formatting a histogram correctly where you have set up the bins exactly.
n the tab labeled "Water Quality" and s indicated there. Start by entering your ated. Pay attention to the legend. This ntly self-grading.
Well
1
Enter Name
Your Name Here
2
Enter Name
3
Enter Name
Bin Table
4
Enter Name
Minimum
5
Enter Name
Maximum
6
Enter Name
Bin Width
7
Enter Name
8
Enter Name
Frequency Distribution
9
Enter Name
Lower Limit
Upper Limit
Title of bin
Frequency
10
Enter Name
11
Enter Name
12
Enter Name
13
Enter Name
14
Enter Name
15
Enter Name
16
Enter Name
17
Enter Name
18
Enter Name
19
Enter Name
20
Enter Name
21
Enter Name
22
Enter Name
23
Enter Name
24
Enter Name
25
Enter Name
26
Enter Name
27
Enter Name
28
Enter Name
29
Enter Name
30
Enter Name
31
Enter Name
32
Enter Name
33
Enter Name
34
Enter Name
35
Enter Name
36
Enter Name
37
Enter Name
38
Enter Name
39
Enter Name
40
Enter Name
41
Enter Name
42
Enter Name
Change in water quality
Input name below to generate the data
Video for
Video
2.
Based on your Frequency Distribution from Part 1, create a histogram a
Title each bin using the Title of Bin from the Frequency Distribution table.
labels and an appropriate chart title.
Put your histogram here. Make sure to label the x-a
appropriately using the "Title of Bins" data. Also m
the chart title and add and set axis titles.
43
Enter Name
44
Enter Name
45
Enter Name
46
Enter Name
47
Enter Name
48
Enter Name
49
Enter Name
50
Enter Name
51
Enter Name
52
Enter Name
53
Enter Name
54
Enter Name
55
Enter Name
56
Enter Name
57
Enter Name
58
Enter Name
59
Enter Name
60
Enter Name
61
Enter Name
62
Enter Name
63
Enter Name
64
Enter Name
65
Enter Name
66
Enter Name
67
Enter Name
68
Enter Name
69
Enter Name
70
Enter Name
71
Enter Name
72
Enter Name
73
Enter Name
74
Enter Name
75
Enter Name
76
Enter Name
77
Enter Name
78
Enter Name
79
Enter Name
80
Enter Name
81
Enter Name
82
Enter Name
83
Enter Name
84
Enter Name
85
Enter Name
86
Enter Name
87
Enter Name
88
Enter Name
89
Enter Name
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help