Home /
Expert Answers /
Statistics and Probability /
the-excel-file-gives-a-big-list-of-responses-from-the-study-and-i-would-like-to-know-what-i-need-to-pa521
(Solved): the excel file gives a big list of responses from the study and I would like to know what i need to ...
the excel file gives a big list of responses from the study and I would like to know what i need to do in excel to get the answers
i do not know how to insert the data, i cant take a photo because it is on excel and has 187 rows.
Many belleve that it is not feasible for men and women to be just friends, while others argue that this belief may not be true anymore because gone are the days when men worked and women stayed at home and the only way they could get together was for romance. A researcher conducts a survey on 186 students. The students are asked their sex (male or female) and if it is feasible for men and women to be just friends (yes or no). A portion of the responses is shown in the accompanying table. Bpicture Click here for the Excel Data File a-1. Construct a contingency table that cross-classifies the data by Sexand Feasible. Provide the frequencies in the accompanying table. Answer is complete but not entirely correct. a-2. How many of the students were female?
Expert Answer
Answer:Consider the following responses of 10 students (for instance to obtain the answer in Excel to know the Excel Steps) as shown below to obtained