Subject Code & Title : BUS105 Computing
Assessment Type : Assignment
“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
1. An excel file with the datasets for all the students , each student must follow the instructions
and get 4 datasets using their student number , each student will have different datasets
2. 3 types of data set summarizer,an excel file that automatically summarizes a data set with 2 quantitative variables an excel file that automatically summarizes a data set with 2 categorical variables an excel file that automatically summarizes a dataset with 1 categorical and 1 quantitative variables
BUS105 Computing Assignment – king’s own institute Australia.
The following material briefly discusses where to find the material for the assignment
Submission :-
1.Students must submit a word file (worth 18%) to Moodle AND an excel file (worth 2%) to moodle
2.The word file needs to be submitted to the Turnitin link – instructions are given on page 6
3.The word file needs a cover page
4. 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 data set and the data set summarizer.
5 The excel file needs to be submitted to the assignment drop box,
6 The excel file should have the student’s 3 datasets and summaries NOT made by the automatic data set summarizer – summarize the data set using Pivot Tables and the scatter plot. (Instructions for submitting the excel file are given on page 8)
BUS105 Computing Assignment – king’s own institute Australia.
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.
BUS105 Computing Assignment – king’s own institute Australia.
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
You will use your datasets and the automatic data set 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)
Data set 1
Version 1 of a pregnancy test results
The variables
Are “Reality, pregnant or not pregnant?” and “Test result, positive or negative?”
BUS105 Computing Assignment – king’s own institute Australia.
Data set 2
Version 2 of a pregnancy test results
The variables
Are “Reality, pregnant or not pregnant?” and “Test result, positive or negative ?”
Data set 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 :
a) Paste data set 1 into an appropriate data set 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
BUS105 Computing Assignment – king’s own institute Australia.
b) Use part a Describe the relationship between the two variables using one of the following numbers, choose the correct option
1. The difference between sample means –
2. The difference between sample proportions –
3. The correlation coefficient r
Your description of the relationship between the variables should also describe the relationship using plain English
c) Paste data set 2 into an appropriate data set 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
BUS105 Computing Assignment – king’s own institute Australia.
d) Use the answer in c) part to describe the relationship between the two variables using one of
the following numbers, choose the correct option
1. The difference between sample means –
2. The difference between sample proportions –
3. The correlation coefficient r
Your description of the relationship between the variables should also describe the relationship using plain English
e) 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
BUS105 Computing Assignment – king’s own institute Australia.
Question 2
Paste the first two variables of data set 3 into a data set 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
i. The difference between sample means –
ii. The difference between sample proportions –
iii. 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 data set 3 into a data set summarizer
a) 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.
b) Looking at the graph does there appear to be one linear relationship or two linear relationships?
c) 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
d) 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.
e) 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.
f) Use the information in part (d) to predict number of people needing tech support if the number of tests is 1000
BUS105 Computing Assignment – king’s own institute Australia.
Question 4
Note that you need the output from question 2 to answer this question
a) Just considering the information from country A
i) What is the estimate of the population mean number of tests
ii) What is the standard error of this estimate?
b) Just considering the people country B
i) What is the estimate of the population mean number of tests?
ii) What is the standard error of this estimate?
Question 5
Note that you need the output from question 1 to answer this question
a) For version 1 of the test find a 95% confidence interval for the proportion of pregnant women that test positive
b) For version 2 of the test find a 95% confidence interval for the proportion of pregnant women that test positive
Question 6
Paste data set 1 into an appropriate data set summarizer
a) 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
b) Comment on the confidence interval
c) Comment on the pvalue
Question 7
Paste the first two variables of data set 3 into an appropriate data set summarizer
a) 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
b) Comment on the confidence interval
c) Comment on the p value
Question 8
Paste the last two variables of dataset 3 into an appropriate dataset summarizer
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
Hint: inferential statistics measure evidence for a claim.
b) 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
c) Which case has a lower standard error the output from part a) or the output from part b)
d) 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?
e) Comment on the confidence interval in part b)
f) Comment on the p value 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.
Upload the word file to the Turnitin link on moodle
Instructions for the excel file ,
This is worth 2% of your final grade
you have to use the excel commands discussed below and not the data set summarizer However you should check that your summaries are the same as the output from the data set 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 data set 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
A) Select all of data set 1 and use excel Pivot Table 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?”
B) Select all the first two variables of data set 3 and use excel Pivot Table 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 ?”
C) Select the last 2 variables of data set 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 ?”
D) Upload the excel file with the pivot tables and scatter plot to the assignment drop box
Excellent Assignment Help
We Aim At:
- Lowest Price.
- 100% Uniqueness.
- Assignment Fastest Delivery.