\nThe outline is set on excel spread sheet, just need assistance with imputing the functions and data on the master sheet, to be able to answer the data analysis: Do Males make more the Females. Can negotiate a fee if interested. <\/p>\n
1\tThe first step in analyzing data sets is to find some summary descriptive statistics for key variables. Since the assignment problems will\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t
\n\tfocus mostly on the compa-ratios, we need to find the mean, standard deviations, and range for our groups: Males, Females, and Overall.\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/p>\n
Males\t\t\t\t\t\tFemales\t\t\t\t\t\tOverall\t\t\t\t
\nMeans\t\t\t\t\t\tMeans\t\t\t\t\t\tMeans\t\t\t\t
\nstandard deviations\t\t\t\t\t\tstandard deviations\t\t\t\t\t\tstandard deviations\t\t\t\t
\nRange\t\t\t\t\t\tRange\t\t\t\t\t\tRange\t\t\t\t<\/p>\n
Data values used: Discriptive Statistic; to show how results are formed. For Examples cell should have an “=XX” formula in them showing the value of the Discriptive statistic table.\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\tif you choose to use generate each value using fx functions,then each function should be inside the cell, along with location of data value in the cell.\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/p>\n
If you use Descriptive statistics, Place the output table in row 1 of a column to the right.\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/p>\n
\n\t\t\t2. Probability\t\t\t\t\t\t\t\t\t\t\t\t\t
\nA key issue in comparing data sets is to see if they are distributed\/shaped the same. At this point we can do this \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t
\nby looking at the probabilities that males and females are distributed in the same way for a grade levels.\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/p>\n
\t\tEmpirical Probability: What is the probability for a:\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/p>\n
\t\ta. Randomly selected person being in grade E or above?\t\t\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\tb. Randomly selected person being a male in grade E or above? \t\t\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\tc. Randomly selected male being in grade E or above? \t\t\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\td. Why are the results different?\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/p>\n
\n3. Normal Curve based probability: For each group (overall, females, males), what are the values for each question below?\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t
\nA. Make sure your answer cells show the Excel function and cell location of the data used.\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\tOverall\t\t\t\t\t<\/p>\n
\t\t\t\t\t\t\t\t\t\t\tFemale\t\t\t\t\t<\/p>\n
\t\t\t\t\t\t\t\t\t\t\tMale\t\t\t\t\t<\/p>\n
\nB. How do you interpret the relationship between the data sets? What does this suggest about our equal pay for equal work question?\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/p>\n
\n4. Based on our sample data set, can the male and female compa-ratios in the population be equal to each other?\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/p>\n
A. First, we need to determine if these two groups have equal variances, in order to decide which t-test to use.\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/p>\n
\tWhat is the data input ranged used for this question: decide equal variance?\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/p>\n
Step 1:\tHo:\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t
\n\tHa:\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t
\nStep 2:\tDecision Rule:\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t
\nStep 3:\tStatistical test:\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t
\n\tWhy?\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t
\nStep 4:\tConduct the test – place cell B77 in the output location box.\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/p>\n
\t\tStep 5:\tConclusion and Interpretation\t\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\t\t\tWhat is the p-value:\t\t\t\t\t\t\t\t\t\t\t\t<\/p>\n
\t\tIs the P-value < 0.05 (for a one tail test) or 0.025 (for a two tail test)?\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\n\n\t\t\t\t\tWhat is your decision: REJ or NOT reject the null?\t\t\t\t\t\t\t\t\t\t\t\n\n\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\tWhat does this result say about our question of variance equality?\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/p>\n
\n\tB\tAre male and female average compa-ratios equal?\t\t\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\t(Regardless of the outcome of the above F-test, assume equal variances for this test.)\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/p>\n
\t\t\t\t\t\tWhat is your decision: REJ or NOT reject the null?\t\t\t\t\t\t\t\t\t\t
\n\t\tStep 1:\tHo:\t\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\t\tHa:\t\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\tStep 2:\tDecision Rule:\t\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\tStep 3:\tStatistical test:\t\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\t\tWhy?\t\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\t4. Conduct the test – place cell B109 in the output location box.\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/p>\n
\t\t\tStep 5:\tConclusion and Interpretation\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\tWhat is the p-value:\t\t\t\t\t\t\t\t\t\t\t<\/p>\n
\t\t\tIs the P-value < 0.05 (for a one tail test) or 0.025 (for a two tail test)?\t\t\t\t\t\t\t\t\t\t\t\t\t\n\n\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\t\tWhat, besides the p-value, needs to be considered with a one tail test?\t\t\t\t\t\t\t\t\t\t\t\t\t<\/p>\n
\n\t\t\tDecision: Reject or do not reject Ho?\t\t\t\t\t\t\t\t\t\t\t\t\t<\/p>\n
\t\tWhat does your decision on rejecting the null hypothesis mean?\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/p>\n
\t\t\tIf the null hypothesis was rejected, calculate the effect size value:\t\t\t\t\t\t\t\t\t\t\t\t\t<\/p>\n
\n\t\tIf the effect size was calculated, what doe the result mean in terms of why the null hypothesis was rejected?\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/p>\n
\t\t\tWhat does the result of this test tell us about our question on salary equality?\t\t\t\t\t\t\t\t\t\t\t\t\t<\/p>\n
\n\t\t6\tConsidering both the salary information in the lectures and your compa-ratio information, what conclusions can you reach about equal pay for equal work?\t\t\t\t\t\t\t\t\t\t\t\t\t<\/p>\n
\n\t\t\tWhy – what statistical results support this conclusion?\t\t<\/p>\n","protected":false},"excerpt":{"rendered":"
The outline is set on excel spread sheet, just need assistance with imputing the functions and data on the master sheet, to be able to answer the data analysis: Do Males make more the Females. Can negotiate a fee if Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-7842","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/7842","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=7842"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/7842\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=7842"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=7842"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=7842"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}