04 - Graphing

xlsx

School

Southern Alberta Institute of Technology *

*We aren’t endorsed by this school

Course

COMP 213

Subject

Statistics

Date

Feb 20, 2024

Type

xlsx

Pages

18

Uploaded by LieutenantFreedom2249

Report
Revenue Jan Feb Mar Apr May Jun Upgrading $234million $53million $240million $423million $403million $356million Transport $35million $43million $309million $409million $423million $388million Extraction $151million $108million $302million $300million $276million $251million Jan Feb Mar Apr May Jun $0million $50million $100million $150million $200million $250million $300million $350million $400million $450million Revenue Upgrading Transport Extraction
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
Use the data in the table to recreate the five charts shown below.
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
DATA SET #1 1 0.5 2 1 4 2.5 9 4.5 12 6.2 15 7.3 7 3.8 DATA SET #2 20 0.5 25 1.5 30 2.5 40 4.5 60 6.2 100 7.3 150 9.1 distance (m) temp. (°C) distance (m) temp. (°C) 1 2 4 9 12 15 7 0 1 2 3 4 5 6 7 8 Line Chart distance (m) temp. (°C) 20 25 30 40 60 100 150 0 1 2 3 4 5 6 7 8 9 10 Line Chart distance (m) temp. (°C) Three data sets have been charted using both "line" and "XY scatter" charts. What differences do you notice between the chart types? Which chart type do you think should be used for each data set? Why? Discus your observastions with your classmates.
DATA SET #3 sample # 101 16.2 102 19.9 103 21.6 104 23.8 105 25.8 measured temp. (°C) 101 102 103 104 105 15.0 17.0 19.0 21.0 23.0 25.0 27.0 Measured Temp. (°C) sample # measured temp. (°C)
0 2 4 6 8 10 12 14 16 0 1 2 3 4 5 6 7 8 XY Scatter Chart distance (m) temp. (°C) 0 20 40 60 80 100 120 140 160 0 1 2 3 4 5 6 7 8 9 10 XY Scatter Chart distance (m) temp. (°C)
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
100.5 101 101.5 102 102.5 103 103.5 104 104.5 105 105.5 15.0 17.0 19.0 21.0 23.0 25.0 27.0 Measured emp. (°C) sample # measured temp. (°C)
Potable Water Analysis Parameter Sample Identification 52503 52504 52601 56020 May 25, 2002 May 25, 2002 May 26, 2002 May 26, 2002 Major Ions and Dissolved Metals Calcium 210 241 163 167 Potassium 9.9 20.3 7.2 5.8 Magnesium 58.3 61.8 44.5 45.2 Sodium 331 566 271 276 Sulfate 579 496 651 562 Chloride (Cl) 481 938 216 301 Nitrate + Nitrite + N <0.1 <0.1 <0.1 <0.1 Iron 0.22 <0.06 2.3 0.14 Manganese 1.88 4.34 0.34 0.08 Fluoride 0.13 0.17 <0.05 0.13 pH, Conductivity and Alkalinity pH 7.2 7.6 7.4 7.7 Conductivity (µS) 2800 4040 2160 2220 201 165 213 178 <5 <5 <5 <5 Hydroxide <5 <5 <5 <5 Total Alkalinity 165 135 175 146 All values expressed in mg/L unless otherwise specified Bicarbonate (HCO 3 - ) Carbonate (CO 3 -2 ) Us rec Thi pro Cre the 0 20 40 60 80 100 120 140 160 180 200
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
e this Potable Water Analysis data to create the three charts shown below. is data is not set up for charting (a common oblem with real world data). eate a blank chart, then right click and use e Select Data tool to complete this exercise. 52503 52504 52601 56020 52601 56020
52503 52504 52601 0 20 40 60 80 100 120 140 160 180
Stream #1 Stream #2 Stream #3 Time Time Time 15 1:30:00 5 1:45:00 1009 1:50:00 500 2:30:00 310 2:45:00 2689 2:50:00 1012 3:30:00 615 3:45:00 3569 3:50:00 1601 4:30:00 902 4:45:00 4223 4:50:00 2025 5:30:00 1236 5:45:00 5892 5:50:00 2630 6:30:00 1599 6:45:00 6988 6:50:00 3200 7:30:00 1883 7:45:00 8012 7:50:00 Total Volume and Time (h) 10,983.00 6 6,550.00 6 32,382.00 6 1,830.50 1,091.67 5,397.00 2,773 Volume Readings (m 3 ) Volume Readings (m 3 ) Volume Readings (m 3 ) Flow Rate (m 3 /h) Average Flow Rate (m 3 /h) Vol ume Rea dings ( m3) 15 500 1012 1601 2025 2630 3200 0 2 4 6 8 10 12
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
1. Plot Time vs Volume using an XY scatter chart. Each stream should be a line (series) on one chart. Modify it so it looks like the chart below. 2. Change the markers so that each line uses a different symbol. This will ensure your chart is readable if printed in black and white. 3. Move the chart to its own sheet. Name this sheet " Production Data-Chart . " The chart should take up the entire sheet (not be an object in the sheet).
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