Please help me with this case study. Thanks

Many companies have been developing new tests to rapidly detect the COVID-19 infections in people. One such company is ABC Ltd. ABC Ltd has developed two different rapid COVID-19 detection tests. Version 1 of the test works by getting patients to blow into a bag. Version 2 of the test requires a nasal swab of the patient. ABC Ltd is now trying to find out which version of the rapid COVID-19 detection test would be most popular with people. Furthermore, the company has been conducting trials of the rapid COVID-19 detection tests to determine which one of the two versions is most accurate in detecting COVID-19 infections. All these issues are critical to the success of the new tests that they have developed and will determine the profitability of the company for the next 5 years.

To assist ABC Ltd in determining which of the two tests are most popular with people and which of the two tests is most effective in detecting COVID-19 infections, researchers have collected data and have provided you with these datasets.

The Datasets

Dataset 1

This dataset contains the results of a market research conducted by ABC Ltd. In the market research, the researchers presented information about the two new COVID-19 detection tests to randomly selected people from the general population who participated in many focus groups of 25 to 30 people. The market researchers then recorded the number of people who expressed an interest in buying each version of the COVID-19 detection test for each focus group. Therefore, this dataset contains the following variables:

Variable 1: Version of COVID-19 detection test (Version 1 or Version 2?)

Variable 2: Number of people that would buy the COVID-19 detection test

There is a third column of data in this dataset, Focus Group ID. This variable identifies the focus group and should not be used as a variable in your analysis. However, you can use Focus Group ID to transform the dataset into an additional dataset for your analysis.

Dataset 2

Dataset 2 contains the results of a trial use of Version 1 COVID-19 detection test. The trial run was conducted to check the accuracy of Version 1 COVID-19 detection test. Unfortunately, not everyone with COVID-19 infection received a positive result from Version 1 of the COVID-19 detection test. Furthermore, there were a few patients who tested negative from Version 1 test but were infected with COVID-19.

The variables in this dataset were as follows:

Variable 1: Does the patient really have COVID-19 infection (Has COVID or Does not have COVID)

Variable 2: Did the patient test positive or negative for COVID-19 (Positive or Negative)

Dataset 3

This dataset is the same as dataset 2, except it contains the results of a trial use of Version 2 COVID-19 detection test.

The tasks

You need to process and analyse the sample datasets 1 to 3, provided to you in MS Excel. For each dataset, generate and analyse descriptive statistics to describe sample characteristics. This will involve, at least, the following analysis: Frequency (counts), proportions, means, standard deviations and correlation analysis. Then use inferential statistics to measure the accuracy of the descriptive statistics for the sample datasets. Based on your analysis of the datasets, answer questions such as:

Which COVID-19 detection test do people prefer to purchase?

Which COVID-19 detection test is more accurate?

Executive Summary- Present the major findings and major recommendations from your analysis. This should be the first part of the report but you should do everything else first before writing the summary.

Dataset Dataset 2 Dataset 3 Version 1 of rapid COVID- Version 2 of rapid COVID-19 19 detection test detection test Number Did the Did the of people patient patient that test test Version would positive positive of buy the or or COVID- COVID. negative negative Focus 19 19 for for Group detectiondetection Does the patient really have COVID- Does the patient really have COVID ID test test COVID-19 infection 19 ( COVID-19 infection 19 1version 18 has covid does not have covid 1version 2 13 does not have covid has covid 2version 1 12 has covid has covid 2version 2 12 has covid does not have covid 3version 1 does not have covid does not have covid 3version 2 does not have covid has covid 4version 1 14 does not have covic does not have covid 4version 2 12 does not have covic has covid 5version 1 14 does not have covid does not have covid 5version 2 10 has covid has covid 6version 1 11 does not have covid does not have covid 6version 2 10 has covid does not have covid 7version 1 16 does not have covid has covid 7version 2 13 does not have covid as covid 8version 1 17 has covid does not have covid 8version 2 15 does not have covid as covid 9version 1 15 has covid does not have covid 9version 2 14 does not have covid does not have covid 10version 1 12 does not have covid does not have covid 10version 2 does not have covid has covid 11 version 18 has covid does not have covid 11 version 2 16 has covid as covid 12version 15 does not have covid does not have covid 12version 2 has covid as covid 13version1 has covid does not have covid 13version 2 14 does not have covid has covid 14version 1 12 has covid does not have covid 14version 2 11 does not have covid has covid 15version 1 does not have covid does not have covid 15version 2 has covid does not have covid 16version 1 does not have covid does not have covid 16version 2 does not have covic does not have covid 17version does not have covid does not have covid 17version 2 does not have covid does not have covid 18version 1 does not have covid does not have covid 18version 2 does not have covid as covid 19version 1 does not have covid as covid 19version 2 does not have covid does not have covid 20version 1 does not have covid has covid 20version 2 13 has covid as covid 21version 1 11 does not have covid as covid 21version 2 does not have covid as covid 22version 1 has covid as covid 22version 2 does not have covid as covid 23version 1 does not have covid as covid 23version 2 11 does not have covid as covid 24version 1 15 does not have covid does not have covid 24version 2 14 has covid has covid 25version 1 15 has covid does not have covid 25version 2 15 does not have covid does not have covid 26version 1 15 has covid as covid 26version 2 14 has covid has covid 27version 1 14 does not have covid does not have covid 27version 2 12 has covid does not have covid 28version 1 16 has covid does not have covid 28version 2 13 does not have covid has covid 29version 1 11 has covid has covid 29version 2 does not have covid does not have covid 30version 1 does not have covid does not have covid 30version 2 15 has covid does not have covid 31version 1 13 does not have covid does not have covid 31 version 2 10 has covid has covic 32version 1 16 has covid has covid 32version 2 12 has covid does not have covid 33version 1 18 does not have covid has covid 33version 2 14 does not have covid does not have covid 34version 1 13 has covid does not have covid 34version 2 11 has covid has covid 35version 1 16 does not have covid does not have covid 35version 2 11 has covid has covic 36version 1 12 does not have covid has covid 36version 2 12 has covid has covid 37version 1 13 has covid has covid 37version 2 10 has covid does not have covid 38version 1 16 does not have covid has covid 38version 2 15 has covid has covid 39version 1 14 has covid does not have covid 39version 2 14 does not have covid has covid 40version 1 16 has covid has covid 40version 2 12 does not have covid has covid 41 version 1 17 has covid does not have covid 41 version 2 14 does not have covid has covid 42version 1 14 has covid does not have covid 42version 2 10 has covid does not have covid 43version 1 14 has covid has covid 43version 2 11 does not have covid has covid 44version 1 16 does not have covid does not have covid 44version 2 11 has covid has covid 45version 1 15 has covid does not have covid 45version 2 15 does not have covid has covid 46version 1 11" does not have covid does not have covid 46version 2 has covid does not have covid 47version 1 18 does not have covid has covid 47 version 2 14" has covid does not have covid 48version 1 12 has covid has covid 48version 2 11 does not have covid has covid 49version 1 22 has covid has covid 49version 2 17 has covid does not have covid 50version 1 does not have covid as covid 50version 2 does not have covid has covid