How do I create a frequency table and summary table without the ability to use statistical software R? I have the file with all of the data imported into excel but the file is too large to post.

For this project, we will use the North a birth data set nebirth1450.cav. In this assignment you will test hypothe mage, s, tounces, low, and amoke. Variable Label|Description plurality Number of children born of the pregnancy Bex Sex of child (1-Male, 2-Female) mage Age of mother (years weeks Completed Weeks of Gestation (week marital Marital status (1-married, 2 racemom Race of Mother (0-Other Non-white, 1=White, 2 Black 3-American Indian, 4-Chinese, 5-Japanese, 6-Hawalian, 7-Filipino, 8-Other Asian or Pacific Islander) hispmom Mother of Hispanic origin (C-Cuban, M-Mexican, N-Non-Hispanic, 0-Other and Unknown Hispanic, P-Puerto Rican, S-Central/South American, U-Not Classifiable) gained Weight gained during pregnancy (pounds) smoke )=mother did not smoke during pregnancy 1=mother did smoke during pregnancy drink 0-mother did not consume alcohol during pregnancy 1-mother did consume alcohol during pregnancy tounces Weight of child (ounces) tgrams Weight of child (grams) low 0-infant was not low birth weight 1-infant was low birth weight Premie 0-infant was not premature 1-infant was premature premature defined at 36 weeks or sooner 1. Please begin the assignment by deleting the items with missing values ("#NULL!") in it and do analysis only on the remained data set (hint: use the code provided in class). Please provide a frequency table for the percentage of low birth weights and a frequency table for the percentage of smokers. Create a summary table (mean, median, standard deviation, minimum, maximum) for the continuous variables of mage, weeks, and tounces. 2. With the information that you gather from this summary, test the following: (a) Determine if there is sufficient evidence to conclude the mean age of mothers giving birth in North Carolina is over 25 years of age at the 0.05 level of significance. b) Determine if there is sufficient evidence to conclude the mean weeks of gestation of mothers giving birth in North Carolina is below 39 weeks. (c) Determine if there is sufficient evidence to conclude that the mean weight of babies born to mothers in North Carolina is above 7 Ibs. (Note that there are 16 ounces in a pound.) (d) Construct a side-by-side boxplot for tounces for smokers and non-smokers. Comment on whether you believe you will reject or fall to reject the null hypothesis. Determine if there is sufficient evidence to conclude the mean tounces of smoking mothers is lower than the mean birth weight for non-smoking mothers. For each of the tests above, in your report. be sure to 1. Clearly state a null and alternative hypothesis 2. Give the value of the test statistic 3. Report the P-value 1. Clearly state your conclusion (Le. ' Reject the Null' is not sufficient) 3. Lastly. propose and conduct your own test of hypotheses. You can test a single mean, a single proportion or compare two means for two independent groups. Make sure your test follows the four steps above