Read Lecture 3. React to the material in this lecture. Is there anything you found to be unclear about setting up and using Excel for these statistical techniques? Looking at the data, present an ANOVA on the differences by grade mean on a variable—other

profileMichelle_Michy
doc1.doc

BUS 308 Week 3 Discussion 3

 Week 3 Excel Details

Read Lecture 3. React to the material in this lecture. Is there anything you found to be unclear about setting up and using Excel for these statistical techniques? Looking at the data, present an ANOVA on the differences by grade mean on a variable—other than compa-ratio or salary—you feel might be important in answering our equal pay for equal work question. Interpret your results.

React to the material in this lecture.

The week 3 lecture 3 discusses Chi Square tests, how to set up the corresponding data tables, and how to conduct the Chi Square tests on distributions. It is interesting that the ANOVA tests learned about in week 2 can only be calculated using the Data Analysis Tool in Excel and not the Fx formulas and the Chi Square test can only be calculated by the Fx formulas found in Excel and not the Data Analysis Tool. The Chi Square test evaluate patterns and distributions and not means and standard deviations. The lecture discusses two types of Chi Square tests. The Goodness of Fit test involves a single row of counts and the Contingency Table analysis involves multiple rows in the table. The assignment asks for a Contingency Table analysis.

Is there anything you found to be unclear about setting up and using Excel for these statistical techniques?

This lecture was initially very confusing to me. The data provided to help us work through the Chi Square tests was graduate and undergraduate degrees and not the male and female compa-ratio distributions. Reading through the text several times and watching the provided video link helped with comprehension and understanding.

Peer Responses:

Briana Watson:

Briana,

By reading your discussion posts during the first three weeks of our class, you have a solid grasp of the material. I used the “grade” and “gender1” column headings under the data tab in the Excel spreadsheet to fill in the actual and expected distributions in question 3 regarding compa-ratios. Based on that data, the P-value was 0.035579215. I substituted the salary information provided in the data set, along with the “grade” and “gender1” column headings to calculate the P-value for the week 3 assignment. Am I using the right information within the data set?

Mike

Corrina Guitron:

This week’s lecture three was a bit confusing to me about what information in the data set to use for the Chi Square tests. I do recommend reviewing the link, https://screencast-o-matic.com/watch/cb6jffIk8T in the lecture about setting up the data for the Chi Square test. I am going to take advantage of the free 24/7 tutor services Ashford University provides to get a better grasp of the material and the assignment requirements. Best of luck to you.