Destiny Denson Milestone 1

.docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

515

Subject

Statistics

Date

Feb 20, 2024

Type

docx

Pages

1

Uploaded by DeaconSeaLionMaster750

Report
Destiny Denson 1. First Impressions: Look at the Excel file and discuss the following: What kind of information do you think this data set contains? Identify the different column headers. Based on what you see, make your best approximation about the type of information included in this data set. Given this data set we know that the three columns are year, month, country, temperature and rainfall. So based upon the information given I know that the data based upon the year, the month, country, temperature and with all of these it may possibly affect the rainfall. 2. Mean, Minimum, and Maximum: Choose two different columns and calculate the mean, minimum, and maximum of each of the columns. Record your column selections and your results. Calculate the mean, minimum, and maximum of the corresponding columns in the other tab (for example, if you calculate using the Firefighter tab first, move to the Police tab next and do the calculation on the column with the sameheader). The average temperature given in this data set is 9.155048. The average rainfall given in this data set is 104.0032. The minimum temperature -0.1819 and the maximum is 17.3942. The minimum rainfall 19.4244 and the maximum is 233.083. 3. Findings: Now that you have completed the above, discuss the findings from your data assessment. For example, discuss why you chose to look into certain columns or rows and what the answers have revealed about the potential of the information housed in the data. Consider what questions arose as you were looking at the data. The columns I chose to look into were the rainfall and the temperate given the data I feel these two categories will exemplify more information. The minimum and maximum given for both data sets tell us the largest and smallest number given on the data set. The average us giving me an exact representation of the data. Using the information I can tell if I have extreme outliers and variations. 4. Next Steps: Describe what you plan to do to further analyze the data. For example, how might you reorganize the data, or what columns and rows are you particularly interested in analyzing further? Be sure to explain your rationale. To further analyze the data I plan to do a comparison and contrast of temperature to rainfall correlation. Is there a direct or indirect relationship between the temperature and rainfall? Determining the IQR and standard deviation of the data set.
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help