Excel Lab 4-Guide
The following assignment is to be done in Microsoft Excel.
Download the Excel Lab 4 Data Excel file in D2L/Content/ Excel Lab 4. Open it.
1. Problem 1: Point Estimate, Confidence interval, and Test of significance for proportion in Excel.
Make sure you are on Problem 1 sheet.
The CDC reports vital statistics for all births in the US each year. We use a random sample of data from 2014 for two variables in this problem.
The WIC variable indicates whether the WIC food stamp program was used or not (N for No, Y for Yes) by the mother.
Note that these data are categorical (qualitative). Further, there is not much of meaningful information by sorting those and hence these data are nominal.
The Race variable indicates the race of the mother.
Note that this is a label to given each person at birth and each person has one of the race labels. Therefore, these data are categorical (qualitative). Further, there is not much of meaningful information by sorting those and hence these data are nominal.
The two-way (or pivot) table summarizes the number of mothers who used and did not use the WIC food stamp program by their racial group. Note that the total number of mothers belong to each racial group given on the last column of the table are not equal.
Different parts of this problem estimate or test about true proportion of mothers who used WIC within each racial group.
Please read each part carefully and provide answers on the Excel sheet.
For Parts c and d, you should change the numbers on GREEN highlighted cells and then you will see the values on the bellow cells change accordingly.
Please DO NOT change anything on those non-highlighted cells. There are formula written on those cells. At the end, SAVE the Excel file with your answers.
2. Problem 2: Point Estimate, Confidence interval and hypothesis testing for mean in Excel.
The second sheet (Problem 2) in the Excel file has the data for the birth weight of babies based on a random sample of data obtained from CDC in 2014.
The Weight variable gives the weight (in grams) of baby at birth.
Note that the average or minimum weight of baby makes sense and therefore, these data are numerical (quantitative). Further, these data are ratio because there is a true zero and division as well as difference of two ages makes sense. In addition, these are, in general, measured values and hence continuous.
Problem 2 Part (a) (ii)
First, we perform a hypothesis test about true (or population) mean birth weight of babies in US in 2014. Note: if you are using XLSTAT in Excel, then please watch the video at the following link to perform a hypothesis test: https://www.youtube.com/watch?v=G7CtNoX7gO8
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
