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.
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
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
90
Enter Name
91
Enter Name
92
Enter Name
93
Enter Name
94
Enter Name
95
Enter Name
96
Enter Name
97
Enter Name
98
Enter Name
99
Enter Name
100
Enter Name
101
Enter Name
102
Enter Name
Legend
If a cell is shaded
You should
Blue
Enter a text response
Green
Enter a number
Gold
Enter an Excel formula
Any other color
Make no changes
Relative Frequency
r this
for the histogram if using online Excel
1.
Create a frequency distribution of the water quality differences for the 102 well
First, Insert your name into cell D2 and hitting enter. Then find the Minimum, Max
data using Excel formulas with cell references and Excel built-in functions where ap
Minimum, Maximum, and Bin Width as Numbers with 1 decimal places.
Next, find the lower limit and upper limit of each class using the Bin Table values b
frequency for each of those classes. Also, find the relative frequency for each class
reflect the midpoint of the lower and upper limits. Excel formulas with cell referen
calculations. Format all lower and upper limits, and bin titles as Numbers with 1 decimal places.
Numbers with 0 decimal places and format relative frequencies as Percentages wit
and place it below. . Please include axis axis make sure to set
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
ls. ximum, and Bin Width of the ppropriate. Format the below, and then find the s. The title of the bin should nces should be used for all . Format all frequencies as th 0 decimal places.
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