Excel Homework
Jcotto1990This 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 value
Standard Deviation Standard Error
98% 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.
- 6 years ago
- 10
Purchase the answer to view it
- ExcelHomework.xlsx
- Reforms
- leadership model
- FIN 200 Week 1 Assignment Cash Flow Preparation
- Assignment1: Complexities of the U.S. Financial System
- prof moses
- Using the Cash Budget spreadsheet, calculate detailed company cash budgets for the forthcoming and subsequent years. Summarize the sources and uses of cash, and identify the external financing needs for both the forthcoming and subsequent years.
- "For Helpclick Only"
- PROJ 592 All Assignments Week 1, 2 and 5
- Algebra questions
- 5 page paper will pay $5 can u do it?