ZuoTi.Pro
Question

Month Period Gas Usage 40544 1 202 40575 2 204 40603 3 198 40634 4 102...

Month Period Gas Usage
40544 1 202
40575 2 204
40603 3 198
40634 4 102
40664 5 58
40695 6 20
40725 7 18
40756 8 16
40787 9 18
40817 10 58
40848 11 154
40878 12 192
40909 13 206
40940 14 220
40969 15 202
41000 16 98
41030 17 48
41061 18 21
41091 19 17
41122 20 15
41153 21 38
41183 22 62
41214 23 198
41244 24 240
41275 25 247
41306 26 246
41334 27 176
41365 28 110
41395 29 48
41426 30 21
41456 31 16
41487 32 14
41518 33 37
41548 34 98
41579 35 146
41609 36 197

Question 1.

On the sheet titled “Student GPA” from the data create a bar chart. With bins of 50, 60, 70, 80, 90.

(Using either the Frequency Function, or Histogram function in data analysis toolpak.)

  1. Title the chart Student GPA.
  2. For a Histogram remove the gaps between the bars.

Question 2. (6 marks)

On the sheet titled “Gas Usage”, find the following descriptive statistics.

  1. Mean
  2. Mode
  3. Median
  4. Variance
  5. Standard Deviation
  6. Sample Size
math   Statistics-And-Probability   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

t: 2 Cof 196 14 14 225 2. I5 256 16 32 17 289 18 36 8. 324 20 400 20 21 2. 10 441 42 37 1 11 12 37 1369 38 38 1444 48 96 14 23961 Efixi Efi 110.02 %3D Meam = 36 Mediam Efi 36 N/2 = 18 or Alightly value equal to 18 In ct column, the median. will be gu

0 0
Add a comment
Know the answer?
Add Answer to:
Month Period Gas Usage 40544 1 202 40575 2 204 40603 3 198 40634 4 102...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • 1. The data set on sheet #1 gives data on GPA category and number of hours studied. Construct com...

    1. The data set on sheet #1 gives data on GPA category and number of hours studied. Construct comparative box plots of the data first GPA category. Then conduct two-sample t-test on the data for whether GPA category influences the number of hours studied. Be prepared to explain the results of the test and the meaning of the boxplots and how they relate to each other. Then redo the analysis by replacing the ordinal GPA category with a numerical dummy...

  • 2. After building a scientific way for demand forecasting, Mary hoped Jason can propose the optimal...

    2. After building a scientific way for demand forecasting, Mary hoped Jason can propose the optimal inventory/ordering policies for these 4 products for the first week of 2018. The sale price/unit for each product is listed below: Product A =$230 Product B=$50 Product C=$5 Product D=$3 Jason decided to use ABC rule to classify these 4 products. ‘A’ category product(s) will have the target service level 95%. ‘B’ product(s) will have the target service level 90% and ‘C’ products(s) will...

  • data: (copy and paste in excel to view columns in alignment) Sample   Repair Time (days) 1  ...

    data: (copy and paste in excel to view columns in alignment) Sample   Repair Time (days) 1   12 2   17 3   9 4   16 5   10 6   18 7   12 8   14 9   15 10   14 11   14 12   8 13   11 14   10 15   8 16   8 17   14 18   12 19   14 20   13 21   12 22   15 23   15 24   10 25   24 26   17 27   13 28   15 29   13 30   15 31   36 32   40 33  ...

  • Select the group of the periodic table with a condensed electron configuration of [X]ns 2n-1)d10np5. 2...

    Select the group of the periodic table with a condensed electron configuration of [X]ns 2n-1)d10np5. 2 Cayo The Mompanies, Ine. Permon required for production or MAIN-GROUP ELEMENTS Metal (main group) MAIN-GROUP Metals (ansition ELEMENTS Metals (inner transition 1A Metode (0) Normal (18) H 2A 2 1.000 123 JA 4A SA GA 7A He (13) (14) (15) (16) (17) K1003 LI Be 5 6 7 10 6.941 2012 B с N o Ne 10.81 12.01 14/01 16.00 19.00 2018 12 TRANSITION...

  • A partial payment is made on the date indicated. Use the United States rule to determine...

    A partial payment is made on the date indicated. Use the United States rule to determine the balance due on the note at the date of maturity. (The Effective Date is the date the note was written.) Assume the year is not a leap year. Effective Partial Payment Maturity Principal Rate Date Amount Date Date $4000 4% April 1 $1000 May 1 June 1 Click the icon to view a table of the number of the day of the year...

  • 33 On May 6, Jim Ryan borrowed $14,000 from Lane Bank at 7 % interest. Jim...

    33 On May 6, Jim Ryan borrowed $14,000 from Lane Bank at 7 % interest. Jim plans to repay the loan on March 11. Assume the loan is on ordinary interest. How much will Jim repay on March 11? (Use Days in a year table) (Round your answer to the nearest cent.) Jm repay etbook 7-1 TABLE Exact days-in-a-year calendar (excluding leap year)" Day of month 30 31 30 31 28 31 30 31 31 30 31 31 Dec Mar...

  • Sample A SUBJ WTPRE WTPST Sa SEX WTLOSS var 1 165 160 M -5 2 202...

    Sample A SUBJ WTPRE WTPST Sa SEX WTLOSS var 1 165 160 M -5 2 202 200 M -2 3 256 259 M 3 4 155 156 M 1 5 175 162 M -13 6 180 187 M 7 174 172 M -2 8 136 138 M 2 9 168 162 M -6 10 155 155 M 0 11 220 205 M - 15 12 163 153 M -10 13 159 150 M -9 14 253 255 F 15 138...

  • "1",4.69816621546105 "2",4.44756510829146 "3",6.84100846766469 "4",7.01358258791867 "5",3.12935822296976 "6",5.14762683649335 "7",2.54905695207...

    "1",4.69816621546105 "2",4.44756510829146 "3",6.84100846766469 "4",7.01358258791867 "5",3.12935822296976 "6",5.14762683649335 "7",2.54905695207479 "8",4.06103182893184 "9",2.48237691955398 "10", 6.2004516591676 "11", 3.01735627817734 "12", 3.54398983209343 "13",5.02652010457958 "14", 5.94118091122925 "15", 7.01208796523191 "16",1.78016831028813 "17",4.33834121978255 "18", 8.93218857046722 "19", 8.43778411332812 "20",8.85822711493131 "21",4.75013154193281 "22", 9.31373767405901 "23",4.09575976019349 "24",2.74688111585186 "25", 3.8040095716617 26",9.34905953037803 "27", 5.87804953966622 "28",7.30637945593767 "29",7.14701470885807 "30",4.48962722844458 "31", 5.04849646123746 "32", 3.97515036133807 "33", 5.32546715405807 "34",8.17769559423788 "35", 6.42260496868865 "36",7.81161965525343 "37",9.8499408616349 "38",9.93608614628273 "39",8.04555405523207 "40",4.14121187997945 "41",5.19842955121368 "42",6.43976800531653 "43", 5.06797870826443 "44",3.79022295456759 "45",8.64229620362652 "46",10.7203765104341 "47",5.45008418851375 "48",4.96026223624637 "49",3.35515355305645 "50",4.3593298786236 Problem 2: Load in the file "data.csv". Assume that this is a random sample from...

  • Partial payments are made on the dates indicated. Use the United States rule to determine the...

    Partial payments are made on the dates indicated. Use the United States rule to determine the balance due on the note at the date of maturity. (The Effective Date is the date the note was written.) Assume the year is not a leap year. Effective Partial Payment Maturity Principal Date Amount Date Date $1900 19% Sept. 1 $500 Oct. 1 Dec. 1 $500 Nov. 1 Click the icon to view a table of the number of the day of the...

  • 'Student Pair' 'Standard Teaching Method' 'New Teaching Method' 1 51 67 2 72 90 3 85...

    'Student Pair' 'Standard Teaching Method' 'New Teaching Method' 1 51 67 2 72 90 3 85 82 4 51 63 5 73 76 6 72 73 7 65 78 8 72 94 9 72 85 10 95 100 11 70 80 12 60 72 13 57 100 14 48 58 15 74 89 16 63 97 17 82 88 18 57 45 19 87 81 20 65 99 21 48 69 22 97 70 23 61 47 24 83 73...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT