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.

Your 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?

You will write a 2,000-word report presenting your analysis and findings. The report should be structured as follows:

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.

Introduction Provide a background of rapid COVID-19 detection tests and explain the issues and problems with these tests. Outline the purpose of the report. For the background, you will need to conduct research related to the datasets and rapid COVID-19 detection tests. The purpose of the report should become more clear after finding and explaining the descriptive and inferential statistics.

Methodology - Describe the methodology used for data analysis and justify your choice.

Analyses and findings - Analyse the datasets to turn the data into useful information as follows:

Descriptive statistics: Sample characteristics will be described with descriptive analysis. This will include, at least, the following analysis: Frequency (counts), proportions, means, standard deviations and correlation.

Inferential statistics: Inferential statistics will be used to measure the accuracy of the descriptive statistics used in the report. For example, for at least two sample averages find a 95% confidence interval for the population average and for at least two sample proportions find a 95% confidence interval for the population proportion

Discussion and managerial advice Provide a discussion of the results. Discuss which COVID-19 detection test is more popular and which is more accurate.

Limitations and directions for future research - Suggestions of how the research can be improved. You can suggest a very advanced study with many variables. You can propose new variables. You can discuss the problems with a small sample size.

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