Excel homework | Civil Engineering homework help

This is a Excel worksheet, 
    
1. The data given in file HW_Rainfall_Data shows the amount of precipitation, measured in inches, per month and per year from 1928 to 2011. 
a.- For each month, January to December, determine the following statistics characteristics: 
Mean valueStandard Deviation Standard Error98% Confidence Interval 
b.- Plot mean rainfall vs. months of the year and predict during which month of the year we can expect the largest precipitation. Use a column graph and include error bars showing the 98% confidence interval. Read section 3.4.5 in your textbook about adding error bars. 
  
c.- Perform a statistical analysis for the month of September. Include in your analysis: 
i.-Histogramshowingthefrequencydistributionof amountof rainfall/month during those 84 years. Use intervals (bins) of 2 inch. 
ii.- Plot the cumulative distribution function corresponding with the histogram in the same plot, and determine the probability of having a total rainfall above 10 inches that month. 
iii.- Create a pie graph showing the relative frequency (%) corresponding with the histogram. 
iv.- Plot the probability density function and determine if the data can be well represented using the normal Gauss distribution. 

What Students Are Saying About Us

.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐
"Honestly, I was afraid to send my paper to you, but splendidwritings.com proved they are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"

.......... Customer ID: 14***| Rating: ⭐⭐⭐⭐⭐
"The company has some nice prices and good content. I ordered a term paper here and got a very good one. I'll keep ordering from this website."

"Order a Custom Paper on Similar Assignment! No Plagiarism! Enjoy 20% Discount"