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

Similar Solved Questions

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...
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?...
What is the first differential of y = t^(3/2)(16-sqrtt)?
What is the first differential of y = t^(3/2)(16-sqrtt)?...
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...
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...
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...
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...
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 й — ДА...
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...
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?...