Follow the directions which are highlighted in light blue and answer the questio
ID: 3048250 • Letter: F
Question
Follow the directions which are highlighted in light blue and answer the questions. If at all possible please answer the question using Excel. You can then use the "Snipping Tool" to take a screencap of the answer (if you're using a Windows computer you should be able to search for "snipping tool" and easily use it to take screenshots. I know it's an involved problem, but I've been trying to figure it out on my own; and I just don't think I'm doing it right. Any help would be greatly appreciated!
GENDER Male Female Female Male Male Male Male Male Female Male Female Female Female Male Female Female Male Female Female Male Female Female Male Female Male Male Female Male Female MAJOR EXCEL COMFORT EXCEL COMFORT GUIDE GRADE LEVEL Business Admin High Junior Business Admin Low Sophomore Business Admin Low Sophomore Business Admin Low Sophomore HR Management Low Sophomore Accounting High Junior Business Admin Low Junior Business Econ Low Sophomore Intl Business Low Freshman Accounting Low Sophomore Accounting Low Junior Accounting High Sophomore Accounting Low Sophomore Finance Low Sophomore Accounting Low Sophomore Marketing Low Freshman Business Admin Low Junior Marketing Low Freshman Business Admin Low Sophomore Marketing High Junior Business Admin Low Junior Accounting Low Junior Business Admin Low Sophomore Marketing Low Sophomore Finance High Junior Finance Low Freshman Finance High Sophomore Business Admin Low Sophomore Finance Low Sophomore 1. Create three Pivot Tables with Excel Comfort Guide and Grade Level. Use either variable for values and select "Count". Summarize values in the tables as "% of Grand Total", "% of Row Total", and "% of Column Total". Use these to fill in the blanks below. It is YOUR RESPONSIBILITY to determine which chart to use for each set of Probability questions. Joint and Marginal P(Junior) = P(High) = P(High and Sophomore) = P(High and Junior) = P(Low and Junior) = Conditional - Grade Level Given Excel Comfort P(Sophomore | High) = P(Junior High) = P(Sophomore | Low) = P(Junior | Low) = Conditional - Excel Comfort Given Grade Level P(High | Sophomore) = P(Low | Sophomore) = P(High Junior) = P(Low | Junior) =Explanation / Answer
The pivot tables are as follows: -
P(Junior)=0.3103
P(High)=0.2069
P(High and Sophomore)=0.0690
P(High and Junior)=0.1379
P(Low and Junior)=0.1724
P(Sophomore | High)=0.3333
P(Junior | High)=0.6667
P(Sophomore | Low)=0.6087
P(Junior | Low)=0.2174
P(High | Sophomore)=0.1250
P(Low | Sophomore)=0.8750
P(High | Junior)=0.4444
P(Low | Junior)=0.5556
Count of EXCEL COMFORT Column Labels Row Labels High Low Grand Total Freshman 0.00% 13.79% 13.79% Junior 13.79% 17.24% 31.03% Sophomore 6.90% 48.28% 55.17% Grand Total 20.69% 79.31% 100.00%