1 answer

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

Question:

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

Answers

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

.

Similar Solved Questions

2 answers
How many grams of nitric acid, HNO3, are required to neutralize (i.e. completely react with) 3.33...
How many grams of nitric acid, HNO3, are required to neutralize (i.e. completely react with) 3.33 moles of Ca(OH)2 according to the balanced chemical reaction: 2HNO3 + Ca(OH)2 --> 2H2O + Ca(NO3)2...
1 answer
Container A holds 737 mL of ideal gas at 2.30 atm. Container B holds 114 mL of ideal gas at 4.40 atm. lf the gases are allowed to mix together, what is the resulting pressure?
Container A holds 737 mL of ideal gas at 2.30 atm. Container B holds 114 mL of ideal gas at 4.40 atm. lf the gases are allowed to mix together, what is the resulting pressure?...
1 answer
What is the first differential of #y = t^(3/2)(16-sqrtt)#?
What is the first differential of #y = t^(3/2)(16-sqrtt)#?...
1 answer
Department W had 2,580 units, one-third completed at the beginning of the period; 13,200 units were...
Department W had 2,580 units, one-third completed at the beginning of the period; 13,200 units were transferred to Department X from Department W during the period; and 1,600 units were one-half completed at the end of the period. Assume the completion ratios apply to direct materials and conversion...
1 answer
Which of the following people are structurally unemployed? Select all answer options that apply. Choose one...
Which of the following people are structurally unemployed? Select all answer options that apply. Choose one or more: A. A seasonal drought causes some farm workers to lose their jobs. There just isn’t enough work for them to do. B. A worker on an assembly line loses her job when the company ou...
1 answer
This is a laplace equation in cylinder coordinates: ) 1. (10 points) A solid cylinder of radius a and height h has...
this is a laplace equation in cylinder coordinates: ) 1. (10 points) A solid cylinder of radius a and height h has its curved surface held at 0 °C and its top and base held at a temperature To. Find the steady-state temperature distribution in the cylinder. For your convenience, the PD...
1 answer
3. (20) Fire Heater Specification After the reactor feed leaves the heat exchanger, it enters a...
3. (20) Fire Heater Specification After the reactor feed leaves the heat exchanger, it enters a fire heater. In this unit the stream is further heated from 215°C to 350°C, which requires 4649 kJ/h of heat to be added. To accomplish this, the heat from the combustion of methane gas is used: C...
1 answer
#4 which of the following represent the final product of the below aldol condensation reaction ?...
#4 which of the following represent the final product of the below aldol condensation reaction ? the IR of the product does not have a broad peak around 3300 wavenumbers Which intermediates are formed during the mechanism of the below reaction? Select all that apply. 2 й — ДА...
1 answer
Define Starbucks’ niche in the coffeehouse marketplace, both in its early days and today Discuss the...
Define Starbucks’ niche in the coffeehouse marketplace, both in its early days and today Discuss the factors that caused Starbucks' sales to stumble in the mid-to-late 2000s. If you were the CEO at the time, how would you have reversed this trend? What comes next for Starbucks? What new ma...
1 answer
What are three ways to determine if an observed disease phenotype is inherited?
What are three ways to determine if an observed disease phenotype is inherited?...
1 answer
Two vectors are given as follows: A ⃗= 20 m at 30 degree south of west...
Two vectors are given as follows: A ⃗= 20 m at 30 degree south of west and B ⃗=30 m at NW. (a) Using the graphic technique determine (i) A ⃗+B ⃗ (ii) B ⃗+A ⃗ (iii) A ⃗ - B ⃗ (iv) B ⃗ - A ⃗ (b) Using the component method, repeat the computat...
1 answer
28. Pulse rates In the latest National Health and Nutrition Exami- nation Survey (NHANES 2013/2014 -...
28. Pulse rates In the latest National Health and Nutrition Exami- nation Survey (NHANES 2013/2014 - wwwn.cdc.gov/nchs/ nhanes), pulse rate (30 sec rate multiplied by 2) of 2536 U.S. adults averaged 71.6 beats/min with a standard deviation of 11.5 beats/min. (Data in NHANES) a) Can you apply the Cen...
1 answer
On January 1, 20X2, Plend Corporation acquired all of Stork Corporation's assets and liabilities by issuing...
On January 1, 20X2, Plend Corporation acquired all of Stork Corporation's assets and liabilities by issuing shares of its common stock. Partial balance sheet data for the companies prior to the business combination and immediately following the combination are as follows: Plend Corp. Stork ...
1 answer
Thank you in advance :) What is meant by the term risk-free interest? Why is the...
thank you in advance :) What is meant by the term risk-free interest? Why is the U.S. Treasury bill yield used as the risk free interest rate?...
1 answer
5(a) A company is discussing a $0.5 million loan with a bank. The interest rate is...
5(a) A company is discussing a $0.5 million loan with a bank. The interest rate is 12% compounded annually and the repayment period is 5 years. The bank is offering two options for loan repayment: Option A: Payments are to be received in equal installments at the end of each year. Option B: Interest...