take data that you collect and plot it out onto graphs to see a visual representation of the data.

take data that you collect and plot it out onto graphs to see a visual representation of the data. By simply looking at data on a graph, you can tell a lot about how related your observed data are and if they fit into a normal distribution.   Plot the data or calculate probabilities using excel.

How do you plot this and do the equations in ExceljQuery22405754226016666111_1531535420114??

1.  The mean temperature for the month of July in Boston, Massachusetts is 73 degrees Fahrenheit. Plot the following data, which represent the observed mean temperature in Boston over the last 20 years: 1998  72, 1999 69, 2000 78, 2001 70, 2002 67, 2003 74 , 2004 73,  2005 65, 2006 77, 2007 71, 2008 75, 2009 68, 2010 72, 2011 77, 2012 65, 2013 79, 2014 77, 2015 78, 2016 72, 2017 74

• Is this a normal distribution? Explain your reasoning.
• What is an outlier? Are there any outliers in this distribution? Explain your reasoning fully.
• Using the above data, what is the probability that the mean will be over 76 in any given July? 
• Using the above data, what is the probability that the mean will be over 80 in any given July?

2.A heatwave is defined as 3 or more days in a row with a high temperature over 90 degrees Fahrenheit. Given the following high temperatures recorded over a period of 20 days, what is the probability that there will be a heatwave in the next 10 days?  How do you calculate the probability

• Day 193, Day 288, Day 391, Day 486, Day 592, Day 691, Day 790,  Day 888, Day 985, Day 1091, Day 1184, Day 1286, Day 1385, Day 1490, Day 1592, Day 1689, Day 1788, Day 1890, Day 1988, Day 2090