Cover page for the word file you must ensure you submit the correct file and check you have submitted the correct file. Email [email protected] immediately if you accidentally submit something that has someone else s work.

Title: Semester 3, 2021 BUS105 computing assignment Name: Student number: Sample Number:

I am using the sample that is allocated to me based on my student number

Instructions for the computing assignment word file worth 18% of your final grade and excel file worth 2% of your final grade

Overview

Materials that must be used in the assignment these are provided on moodle

An excel file with the datasets for all the students , each student must follow the instructions and get4 datasets using their student number , each student will have different datasets

3 types of dataset summarizer,an excel file that automatically summarizes a dataset with 2 quantitative variablesan excel file that automatically summarizes a dataset with 2 categorical variablesan excel file that automatically summarizes a dataset with 1 categorical and 1 quantitative variables

The following material briefly discusses where to find the material for the assignment

Submission

Students must submit a word file (worth 18%) to Moodle AND an excel file (worth 2%) to moodle

The word file needs to be submitted to the Turnitin link instructions are given on page 6

The word file needs a cover page

The word file needs the answers to 9 questions given in full detail later in this document a vital part of answering the question is using the dataset and the dataset summarizer.

The excel file needs to be submitted to the assignment dropbox,

The excel file should have the student s 3 datasets and summaries NOT made by the automatic dataset summarizer summarize the dataset using PivotTables and the scatterplot. (Instructions for submitting the excel file are given on page 8)

The Computing assignment also consists of 5 preparation quizzes worth 1% each these preparation quizzes are on moodle.

Instructions for Major part of assignment, the word file worth 18% of your final grade you submit to Turnitin.

Overview

You need to submit a word file with the answers to 9 questions the first 8 questions are about the datasets, the last question is a paraphrasing task (refer to page 6)

You will use your datasets and the automatic dataset summarizer to get the descriptive statistics that are used in questions 1 to 5 and the inferential statistics that are used in question 6 to 8.To check you have correctly obtained your dataset check both p-values are correct when you investigate both categorical variables (question 6 to 8). There will be videos on moodle explaining to check you have properly obtained your sample

Summary of the datasets (questions 1 to 8 are about the datasets)

Dataset 1

Version 1 of a pregnancy test results

The variables

Are Reality, pregnant or not pregnant? and Test result, positive or negative?

Dataset 2

Version 2 of a pregnancy test results

The variables

Are Reality, pregnant or not pregnant? and Test result, positive or negative ?

Dataset 3

Daily flight cancelations at airline ABC

The variables are Which Country

Country A or Country B

Number of tests in one week

Number of people needing tech support

Question 1

Paste dataset 1 into an appropriate dataset summarizer

Paste in the descriptive statistics into the word file. The descriptive sample statistics let you investigate the relationship between the variables Reality, pregnant or not pregnant and Test result, positive or negative using the sample, This lets you check the accuracy of version 1 of the virus test

Use part a Describe the relationship between the two variables using one of the following numbers, choose the correct option

The difference between sample means

The difference between sample proportions

The correlation coefficient r

Your description of the relationship between the variables should also describe the relationship using plain English

Paste dataset 2 into an appropriate dataset summarizer

Paste in the descriptive statistics into the word file. The descriptive sample statistics let you investigate the relationship between the variables Reality, Pregnant or not pregnant and Test result, positive or negative using the sample , This lets you check the accuracy of version 2 of the virus test

Use the answer in c) part to describe the relationship between the two variables using one of the following numbers, choose the correct option

The difference between sample means

The difference between sample proportions

The correlation coefficient r

Your description of the relationship between the variables should also describe the relationship using plain English

Which version of the virus test is better ? , version 1 or version 2? Give a reason for you answer , you can use the answer to part b) and d) as a way of deciding which version is better, you do not have to decide which is worse false positives or false negatives

Question 2

Paste the first two variables of dataset 3 into a dataset summarizer

a) Paste the descriptive sample statistics below. The descriptive statistics let you investigate the relationship between the variables Which country? and Number of tests ? using the sample

b) Use the answer to part a) to describe the relationship by using one of the following numbers, select the correct option

The difference between sample means

The difference between sample proportions

The correlation coefficient r

You should also describe the relationship in plain English

c) Paste in the graph that shows the predicted shape of the histograms if the variables are normally

distributed and compare the centres and the spreads.

d) Suppose you know the quantitative variable is normally distributed for both groups, make a comment about part c)

Question 3

Paste the last two variables of dataset 3 into a dataset summarizer

Paste in the descriptive statistics into the word file. The descriptive sample statistics let you investigate the relationship between the variables Number of tests ? and Number of people needing tech support? using the sample. Obviously paste in the graph as well.

Looking at the graph does there appear to be one linear relationship or two linear relationships?

Repeat part a) but this time only paste in the information from country A , so still select the columns Number of tests and Number of people tech support? but do NOT select any of the rows that are from country B

Using the output from part c) Describe the relationship between the variables using one of

the following numbers, select the correct option

*The difference between sample means

*The difference between sample proportions

*The correlation coefficient r

Your description of the relationship should also include some plain English.

Using the information in part c) Write an equation that lets you predict the number of people needing tech support Y given the number of tests.

Use the information in part (d) to predict number of people needing tech support if the number of tests is 1000

Question 4

Note that you need the output from question 2 to answer this question

Just considering the information from country A

What is the estimate of the population mean number of tests

What is the standard error of this estimate?

Just considering the people country B

What is the estimate of the population mean number of tests?

What is the standard error of this estimate?

Question 5

Note that you need the output from question 1 to answer this question

For version 1 of the test find a 95% confidence interval for the proportion of pregnant women that test positive

For version 2 of the test find a 95% confidence interval for the proportion of pregnant women that test positive

Question 6

Paste dataset 1 into an appropriate dataset summarizer

Paste in the computer output that measures evidence for the claim there is a relationship between the variables Reality, Pregnant or not pregnant ? and Test result, positive or negative if you consider the whole population

Comment on the confidence interval

Comment on the pvalue

Question 7

Paste the first two variables of dataset 3 into an appropriate dataset summarizer

Paste in inferential statistics that measure evidence for the claim there is a relationship between the variables Which country ? and Number of tests? if you consider the whole population

Comment on the confidence interval

Comment on the pvalue

Question 8

Paste the last two variables of dataset 3 into an appropriate dataset summarizer

Paste in computer output that measure evidence for the claim there is a relationship between the variables number of tests? and number of people needing tech support? if you consider the whole population

Hint: inferential statistics measure evidence for a claim.

Just using the information from country A, Paste in computer output that measure evidence for the claim there is a relationship between the variables number of tests? and number of people needing tech support? if you consider the whole population

Which case has a lower standard error the output from part a) or the output from part b)

In both part a) and part b) the computer is trying to find a single linear relationship between the variables, based on your previous work in which case is the output trustworthy?

Comment on the confidence interval in part b)

Comment on the pvalue in part b)

Question 9

Paraphrase one or more of the concepts in of one or more of the videos from the list on the next page and explain how the concept (or concept) is useful in business . A total of 400 words is enough. An easy way to keep the Turnitin match is to give a brief overview of a few different videos it is easier to use your own words when you give a brief overview.

Include screenshots of the video and explain how the image helps explain the message in the video

As an example of screenshot from a video 2 semesters ago

An example of explaining the screenshot

The video was talking about how inferential statistics involves taking a sample to make an estimate of the population and in the screenshot above you can see a lady getting a sample of the chips to test the fat and salt content and this can be used to make an estimate of the whole populaiton.

Question 9 continuedthe videos for question 9

Standard Error (of the sample mean)

Upload the word file to the Turnitin link on moodle

Instructions for the excel file ,

This is worth 2% of your final gradeyou have to use the excel commands discussed below and not the dataset summarizerHowever you should check that your summaries are the same as the output from the dataset summarizer you used in the word file.If you have different information you will get at most 1 out of 2

You need to cut and paste just your dataset into a new excel file and follow the instructions below, DO NOT use a cover page for the excel file, you must check that you have the correct sample

Note that you do not have to use excel to make summaries you can use google sheets

Select all of dataset 1 and use excel PivotTable commands (or google sheet pivot table

commands) to find appropriate sample statistics that let you investigate the relationship between the fields (variables) Reality, pregnant or noy virus? and Test result, positive or negative?

Select all the first two variables of dataset 3 and use excel PivotTable commands (or google sheet pivot table commands) to find appropriate sample statistics that let you investigate the relationship between the fields (variables) Which country? and Number of tests in one week ?

Select the last 2 variables of dataset 4 and use excel commands to make a graph that lets you investigate the relationship between the fields (variables) Number of tests in one week ? and number of people that need tech support ?

Upload the excel file with the pivot tables and scatterplot to the assignment dropbox

**WE OFFER THE BEST CUSTOM PAPER WRITING SERVICES. WE HAVE DONE THIS QUESTION BEFORE, WE CAN ALSO DO IT FOR YOU.**- Assignment status: Already Solved By Our Experts
*(USA, AUS, UK & CA PhD. Writers)***CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS**

- 24/7 Customer Support
- All Subject Areas
- Money-Back Guarantee
- Timely Delivery
- Originality report
- Confidentiality guaranteed

You can get our ideal online homework help services with four easy steps. All you have to do is inform us of your requirements. Immediately we will match with a specialist in your academic discipline. After that, we will track your order, review it to ensure it meets your requirements, and submit it to your email.

Fill in your assignment instructions on the order form

Immediately you contact us for homework help; we will assign your assignment to an academic expert.

We have a team of editors, who will thoroughly review your assignment, ensuring there are no errors before submission

Once we have completed the assignment, we will deliver it to your account. Additionally, we will send a notification to your email.

Once you consult us for homework help online services, you will attest to why we are among the USA's best essay writing services.

Read on and find out some of the features that make our services superlative.

You can confirm that the content you get is original for free using our plagiarism checker.

We offer unlimited access to our essay homework samples.

Once you place an order, we format it accordingly without demanding additional charges.

We offer free unlimited revisions until your assignment is of your desired quality..

We have a team of specialized editors who review your assignment before submission.

You can track the progress of your homework for free.