A

S

D

R

T

Y

U

O

P

Bulriss

GBS$221$

Inferential Statistics Project Project #$2$

This project gives you the chance to use the statistical techniques and concepts covered in Chapters $7-9,$ and Chapter $14.$

Overview: The U$.$S$.$ Department of Agriculture maintains a nutrient database for $100$ nutrients of over $7300$ foods. As part of this assignment, there is an Excel file in Canvas of cereal data from the $2004$ USDA National Nutrient Database for Standard Reference, Release $17.*$ The dataset contains the fat, calorie, carbohydrate, fiber, and sugar data for all $278$ cereal items in the nutrient database $($at that time$)$ that contain standard serving size information. From this data, you will ESTIMATE a population mean and determine an appropriate sample size. With the help of Excel, you can then take a random sample, test a hypothesis, calculate a confidence interval, and compare the results with the actual population data. You will also investigate the correlation between fat and calories.

Data Collection: In the files library in Canvas and attached to the assignment writeup is the Excel file for this project. It is called "Copy of cereal$\_$usda$\_$data$\_$stat$\_$proj$2.$xls$".$ Although the file can be considered a population, you MUST NOT use it in its entirety until part $4!$ POPULATION DATA IS ONLY TO BE USED FOR PART $4.$

Optional Data Analysis: You may choose to analyze data of your choice under the following conditions:

You must pre$-$approve your data selection with the instructor.

$$ The population should contain between $300-1000$ observations.

Data for at least two different variables must be available for correlation analysis.

The data must be accessible to the instructor electronically $($from any data source, including data entry by yourself$).$

Project Requirements

Project Elements: There are $5$ parts to the project and they must be done in order! Label each part as you would a multiple part homework problem, example $1$a$)$

V$1.$ Take a guess

a$.$ Begin with a visual review of data in the fat, calorie, carbohydrate, fiber, or sugar columns. Estimate the population mean for ONE of these variables. Do this withou