View attached explanation and answer. Let me know if you have any questions.

1

Name
Pivotal table
Institution of Affiliation

2

1.
A) The probability of having found after the calculation and using the pivotal table, the
probability is 50% female will be selected
In the students’ portal of the data, what is called the data.Xls files that contain over 200
learners? From the data, which will contain various information is associated with various
information regarding the students. The information will include the age of the student, gender of
the student, what the students will be majoring in, or rather, the name of the course the students
will be taking. The ability of the students to communicate in English, as well as the number of
times the students will spend reading. From the data. Pivotal information provided, the women
abilities, the probability of selecting female will be the same as that of males. It is a somehow
common phenomenon that, men and females in many institutions would be found be to be nearly
the same.
The 50% results of women are gotten after choosing to divide of the A’s and B’s which
results are assumed to be about 3.50. after getting the results, the results are filled in the pivotal
table by carrying out a sample hypothesis to make sure that, that the hypothesis selected does not
deviate much from the random chosen data in the pivotal table. An error of 0.05 is selected to
give the range of difference. The results in the pivotal table are used while making sure that, all
statistics have been tried, these include: the two-tail test, the upper-tail test, as well as making a
comparison with the lower-tail testing. The comparison of the calculated means is done while
creating a connection between the calculated mean as well as the hypothesized mean.

3

B) T…