Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Part I: Descriptive Statistics (Scenario A) Scenario A: National Weather Service Note: The following information and instructions apply to students that have been assigned

1. Part I: Descriptive Statistics (Scenario A)

Scenario A: National Weather Service

Note: The following information and instructions apply to students that have been assigned to Scenario A by the instructor. You can find your scenario assignment in the Final Project Review and Scenario Assignments item in the Module One area of the course. Reach out to your instructor if you have questions about your scenario assignment. If you run into issues and would like to start over with a clean copy of the provided script file (e.g., Milestone1.py), you can click on the gear button, and select Restore current files from the drop-down menu. 

Imagine you are a data analyst working at the National Weather Service. Your primary job is to analyze historical weather data for regions within the United States collected by the agency. Your analysis will lead to updating important weather pattern models based on historical trends and your findings will be published in academic journals. As you can see, it is critical for an analyst to provide accurate analysis of the data so that proper interpretations and publications can be achieved. You are now given a task to analyze historical weather data for the city of Manchester in New Hampshire. You will be using monthly weather data collected for the city of Manchester to finish this task.

Use the following table as a reference guide for the variables of interest for this project.

Variable Definition
EMXP Extreme Maximum Precipitation (Highest monthly maximum precipitation) reported in tenths of a millimeter.
EMXT Extreme Maximum Temperature (Highest monthly maximum temperature) reported in tenths of a degree Celsius.
EMNT Extreme Minimum Temperature (Lowest monthly minimum temperature) reported in tenths of a degree Celsius.
MMXT Mean Maximum Temperature (Average monthly maximum temperature) reported in tenths of a degree Celsius.
MMNT Mean Minimum Temperature (Average monthly maximum temperature) reported in tenths of a degree Celsius.
MNTM Mean Temperature (Average monthly temperature) reported in tenths of a degree Celsius.

Step 1: Import your data set

You will be working with the Manchester Weather data set. To ensure that you analyze the correct data set, make the following edits to the function underneath Step 1: Import your data set in the Tool Panel on the left side of the screen.

Uncomment line 11 Replace '???FILE_NAME???' with 'ManchesterWeather.csv' Replace ???DATASET_NAME??? with manchesterweather 

Step 2: Calculate descriptive statistics for Extreme Maximum Temperature (EMXT)

You will need to calculate the following descriptive statistics for the variable EMXT:

  • Mean
  • Median
  • Variance
  • Standard Deviation
  • Minimum
  • Maximum
  • 25th Percentile
  • 75th Percentile

In order to perform these functions, you need to make the appropriate modifications to correct Python functions within the provided script. In other words, you should:

Uncomment lines 17 - 52 Replace ???DATASET_NAME??? with manchesterweather Replace '???VARIABLE_NAME???' with the variable 'EMXT' 

for each of the required Python functions listed above.

Step 3: Calculate descriptive statistics for Extreme Maximum Precipitation (EMXP)

You will need to calculate the following descriptive statistics for the variable EMXP:

  • Mean
  • Median
  • Variance
  • Standard Deviation
  • Minimum
  • Maximum
  • 25th Percentile
  • 75th Percentile

In order to perform these functions, you need to make the appropriate modifications to associated Python functions listed within the provided script. In other words, you should:

Uncomment lines 56 - 89 Replace ???DATASET_NAME??? with manchesterweather Replace '???VARIABLE_NAME???' with the variable 'EMXP' 

for each of the required Python functions listed above.

Part 1: Descriptive Statistics; Scenario A

In Milestone1.py file, read ManchesterWeather.csv data and calculate descriptive statistics for variables EMXT and EMXP.

Check It!

LAST RUN on 7/16/2019 10:37:12 AM

 

Check 1 failed

.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Internal Control A Managers Journey

Authors: K. H. Spencer Pickett

1st Edition

0471402508, 978-0471402503

More Books

Students also viewed these Accounting questions