[Please name the tab as “Bayes”] The probability of having a…

[Please name the tab as “Bayes”] The probability of having a certain disease is 2.1%. A company invented a test to diagnose this disease. When a person with the disease used this test, there was an 89% chance of testing positive, while a person without the disease had a 3% chance of testing positive. If the test result is positive, what is the probability that the person has the disease? Round to 4 decimal places. (for example, 0.0233333 should be written as 0.0233. If written as 2.3333%, the answer will be incorrect.)

[Please name the tab as “Text”] The left side of the comma i…

[Please name the tab as “Text”] The left side of the comma in the name column data represents the last name, and the right side represents the first name. Please enter how many people have their first name starting with “C” and their last name starting with “S”. Name_Exam1-1.xlsx

Suppose we are working on merging individual data, including…

Suppose we are working on merging individual data, including name, ZIP code, gender, and age, with public data. Individual data is in columns A through F. In general, data collected from individuals is often subject to errors because humans self-report and record the information. Please answer the questions below using the attached data. Xlookup2_Cleaning.xlsx Round all numbers to the second decimal place. There are clearly erroneous observations in the data. Use the information below to identify the erroneous observations and answer the questions. – Human age begins at 0 and generally does not exceed 125 years.- This data was collected from residents of Missouri. Missouri’s ZIP codes range from 63000 to 65999.- The genders identified in this data are Male and Female. Observations with values ​​that do not meet the above criteria are excluded from the data. Then, using the remaining observations, calculate the mean ‘Age’ [Age] and ‘Female’ portion [Female] in percentages.