Statistics: Analyzing Data
Description
Using the supplied WSDOT density data Excel spreadsheet, figure out the answers to these questions and then type them on the spreadsheet where I can easily locate them for grading. Upload your spreadsheet with the answers on it. I will grade it manually.
Data: WSDOT density data.xlsxDownload WSDOT density data.xlsx (attached)
Questions:
1. For day 1 only (30 samples total), what is the density average and standard deviation?
2. For all days and all samples, what is the density average and standard deviation? Remember, these are samples of density, not the entire population.
3. For Day 1 only (30 samples), is the pavement density greater than 91.0% with 95% confidence?
4. For all days and all samples, is the pavement density greater than 91.0% with 95% confidence?
5. What are your answers for #3 and #4 if the density value is 91.5%?
6. What are your answers for #3 and #4 if the density value is 92.0%?
Does what you calculate make sense to you?
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."
