excel assignment Math guruu

At the beginning of this class, you collected some international "flight data" for two times of the year. You were asked if there appeared to be a difference. You now have the tools to answer that question statistically. Go back. Use that data. What do you conclude?

Use the data set "Birthweight_smoker" Is there a difference in birth weight for babies whose mother was a non-smoker vs a smoker? Be sure to include summary statistics and any figures that benefit the analysis. Your response can simply be a paragraph stating yes or no and what parameters indicate there is a statistically significant difference or why the parameters indicate there is not a statistically significant difference.

Use the data set "stkmrkt_season"and perform an ANOVA analysis to determine if there are differences in the months of the year. What is the conclusion? Your response can simply be a paragraph stating yes or no and what parameters indicate there is a statistically significant difference or why the parameters indicate there is not a statistically significant difference. Note: The data source for this is:

• C-C. Chien, C-F. Lee, A.M.L. Wang (2002). "A Note on Stock Market Seasonality: The Impact of Stock Price Volatility on the Application of Dummy Variable Regression Model," The Quarterly Review of Economics and Finance, Vol. 42, pp. 155-162. 

There are three different data sets and each will need to be analyzed and results presented. Think about what you have studied to date (format data, plot data, which analysis to perform, user-friendly, present results and provide the correct evidence supporting your conclusion). Your submission will be on workbook but each data set must be presented and analyzed on a separate tab. Your conclusions/write-up should be a separate tab and include each of the write-ups. The write-ups can (should) be short; three sentences at the most. Include all write-ups on one tab.