Please help with this project, I am a little lost.

Phase One: Select two groups whose data you wish to compare. Examples would be students in the College of Technology study or men vs. women in the College of Technology, or drivers of sports cars vs. non-sports cars. Pick two variables you will use to hours studied each week, and g.p.a.,or miles commuted and number of tickets. The two variables that you pick should be tw The project you select should be something that you actually want to investigate. Part of the project is picking an interesting p The data you use can come from many sources. You can prepare a survey that you can use to collect the data. Alternatively you may find your data on the internet. Data can also be gathered from real life situations such as your job. You will need a minimum of 30 observations from each group you choose - at least 30 women and 30 men for example. Record the results in an EXCEL spreadsheet and then calculate for each group: the mean, the median, and the standard deviati Compare the actual data distribution to the expected percents using the Empirical rule. Is your data normal? Each group must email me regarding your choice of data and your survey (if you are using one) before you begin work. Submi All work must be done in EXCEL. When I click on a cell I will be able to see how you arrived at that answer. The final submission will follow the example below mean median stand dev Men G.P.A. obs1 ... ... obs30 x x x +/- 1 std dev x actual % in this range x% +/- 2 std dev x actual % in this range x% +/- 3 std dev x actual % in this range x% Women G.P.A. obs1 ... ... obs30 x x x Hours obs1 ... ... obs30 x x x Hours obs1 ... ... obs30 x x x x x x x x x x x x x x x x x x x x x You will need to two graphs comparing the two groups values for each variable. In the above example you would have one gra and a second graph comparing the two groups in hours studied. You will need two more graphs showing the relationship between hours studied and g.p.a. - one for men and one for women. The graphs should stand alone such that the reader can understand and interpret them without referring to any external inform Consider the type of graph, legend, and color as important. In addition, run a regression between your two variables for each group ( ex g.p.a. and hours studied). Determine if there Is there really a mathematical relationship between the two. Are the results what you expected? Why or why not? Phase Two Formulate a hypothesis between the two groups. Test with a difference in means test and state your conclusions. You will use a Z test here and you may use any alpha that you choose. For example in the above case you would see if average g.p.a. differs significantly between men and women. Don't forget - a hypothesis test involves a null and alternate hypothesis. Then take your other variable and do a confidence interval for the difference in means. In the above example I would do a con interval for the difference in the average hours taken between men and women I am more than happy to look at your project at any point and make sure you are on the right track. If a grou ollege of Technology study vs. students in the College of Liberal Arts, two variables you will use to compare the two groups, for example les that you pick should be two that you suspect may have a relationship. ect is picking an interesting problem. d 30 men for example. dian, and the standard deviation. ata normal? efore you begin work. Submit your work through the assignment icon x x x ample you would have one graph comparing g.p.a. between men and women or men and one for women. eferring to any external information. died). Determine if there Why or why not? your conclusions. nd women. ove example I would do a confidence the right track. If a group member is not pulling his weight let me know