Question: Can I have help with this worksheet please. B | Cc | D | E | F | G [ H | | | J

Can I have help with this worksheet please.

Can I have help with this worksheet please. B | Cc |D | E | F | G [ H | | |J | K | L General Instructions: Make sure to save this

B | Cc | D | E | F | G [ H | | | J | K | L General Instructions: Make sure to save this Excel file often using the filename "vourname Activity2.xlsx". Please place your name above, then complete the following questions. NOTE: Read the entire document below to get a feel for the activity before continuing. Please gather your data from The Weather Underground (www.wunderground.com) web site that you visited in Activity 1b--using the Almanac/History region of the site. Once complete, submit your answers to this activity by attaching your Excel file through the completion link in the Unit 1 Activity 2 assignment description in Blackboard. www.wunderground.com 1. What were the 31 daily mean (average) temperatures for Jacksonville, Florida in January of 20227 List all 31 in order from coolest to warmest in a column of cells out to the right in Column N with a titie on the data. As a data collection hint, search for Jacksonville and view all 31 days in History by selecting the "monthly\" option when viewing the almanac weather history page and use the lowest "table" data with regard to the daily avg temperature (NOT max or min). Use data collected at Jacksonville International Airport in the history. r r 2. Determine the following statistical measures of this data within cells below using Excel commands (values displaying two decimal places). Make sure you include appropriate units/label (in an adjacent cell) your descriptive statistical values. MEDIAN: MEAN: VARIANCE: MODE: ST. DEVIATION: RANGE: 3. Using Excel processes as appropriate in the area out to the right, create a five-class histogram_on the temperature data for Jacksonville. As described in the Excel guide for Unit 1, adjust defaults to reasonable labels within your graph. Include a title il B s e, @ K| B Cc D E B G H | J K L 3 .Using Excel.grocesses as appropriate in the area out to the right,I create a five-class histogfam on the tmEerature data for Jacksonville. As described in the Excel guide for Unit 1, adjust defaults to reasonable labels within your graph. Include a title and label axes. 4. In the recent past, the National Football League used a list of criteria to determine if a city was a candidate to host the Super Bowl. One such requirement is that the city either must have a domed (i.e. heated) football stadium or that the average daily temperature in January for the city must be 50 F or higher. The Jacksonville stadium does not have a dome. Based on January 2022 data, would Jacksonville satisfy this Super Bowl eligibility criterion? (NOTE: 2014 was the first year since inception of the NFL temp. criteria that the criteria was not applied, and of course the Super Bowl now occurs in early February ) 5. Repeat each of questions 1 through 4 for Kansas City, Missouri using the weatherunderground site. (Use Kansas City International Airport as the site for the history data ). Again, make sure to label your work/results so that there is no confusion as to what each of your value(s) represent. (Note the Kansas City Chiefs do not have a domed stadium.) MEDIAN: MEAN: VARIANCE: MODE: ST. DEVIATION: RANGE: Conclusion on eligibility: c | Db | E [Ee ) H (S | J | K | L RANGE: Conclusion on eligibility: 6. Explain/discuss what role IN GENERAL the range and standard deviation could play in the NFL's decision about the Super Bowl regarding any of the NFL cities without a domed stadium but whose mean temperature is just slightly below 50 F. If the criteria mentioned in #4 was still in effect, should the NFL be willing to still consider such a city? Why or why not

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!