“Cover page for the word file you must ensure you submit the correct file and check you have submitted the correct file. Email XXXXXXXXXX immediately if you accidentally submit something that has...

1 answer below »
“Cover page for the word file you must ensure you submit the correct file and check you have submitted the correct file. Email XXXXXXXXXX immediately if you accidentally submit something that has someone else’s work. “
“Title: Semester 1, 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 get 3 datasets using their student number , each student will have different datasets
· Automatic dataset summarizer.
The following material briefly discusses where to find the material for the assignment
https://youtu.be/vlmfpq8waDs
· Videos that show how to get correct output, note that the vast majority of marks come from commenting on the output
· Use this video to check that you have the correct output for question 1a and 6a and 6c
· https://youtu.be/gBkl9BsFrWs
· Use this video to check that you have the correct output for question 2a and 7a and 7c
· https://youtu.be/yq8D1UULVqY
· Use this video to check that you have the correct output for question 3a and 8a and 8c
· https://youtu.be/3-HXPpAVGKc
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 dataset and the dataset summarizer.
5 The excel file needs to be submitted to the assignment dropbox,
6 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 are videos on moodle explaining to check you have properly obtained your sample
Use this video to check that you have the correct output for question 1a and 6a and 6c
https://youtu.be/gBkl9BsFrWs
Use this video to check that you have the correct output for question 2a and 7a and 7c
https://youtu.be/yq8D1UULVqY
Use this video to check that you have the correct output for question 3a and 8a and 8c
https://youtu.be/3-HXPpAVGKc
The total word count can be less than 1500 words if you are giving answers that demonstrate you have understood the material.
Summary of the datasets (questions 1 to 8 are about the datasets)
Dataset 1
Market research company ABC surveyed a group of 100 people
Some people were given the old version of a product and asked “would you buy it”
Some other people were given the new version of a product and asked “would you buy it”
The dataset is the results of the survey
Dataset 2
Market research company DEF surveyed a group of 100 people
Some people were given the old version of a product and asked “How much would you pay ”
Some other people were given the new version of a product and asked “How much would you pay”
The dataset is the results of the survey
Dataset 3
Market research company GHI surveyed a group of 100 people
The survey questions were
1) How much has your weekly income changed because of the Corona virus
2) How much would you pay for the product
Dataset is the questions and answers to the survey above.
Question 1
Paste dataset 1into the dataset summarizer
a) Paste in the descriptive statistics into the word file. The descriptive sample statistics let you investigate the relationship between the variables “Which version?” and “would you buy ?” using the sample
b) Describe the relationship between the variables without using any numbers
c) 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
Question 2
Paste dataset 2 into the dataset summarizer
a) Paste the descriptive sample statistics into the word file. The descriptive statistics let you investigate the relationship between the variables “which version?” and “How much would you pay?” using the sample
b) Use the output in part (a) to describe the relationship between the two variables, do not use any numbers in your discussion
c) Also 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
Question 3
Paste dataset 3 into the dataset summarizer
a) Paste in the descriptive statistics and the scatterplot into the word file. The descriptive sample statistics let you investigate the relationship between the variables “Change in income?” and “How much would you pay?” using the sample
b) Describe the relationship between the variables without using any numbers
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
d) Write an equation that lets you predict the how much they would pay Y given the change in income X
e) Use the information in part (d) to predict the how much they pay if the change in income is -100
Question 4
Note that you need the output from question 2a to answer this question
a) Just considering the people that have the new version
i) What is the estimate of the population average of the amount they would pay?
ii) What is the standard error of this estimate.
b) Just considering the people that have the old version
i) What is the estimate of the population average of the amount they would pay?
ii) What is the standard error of this estimate.
Question 5
Note that you need the output from question 1a to answer this question
a) Just considering the people that have the new version find a 95% confidence interval for the proportion of people that would buy the product
b) Just considering the people that have the old version find a 95% confidence interval for the proportion of people that would buy the product
Question 6
Paste dataset 1 into the dataset summarizer
a) Paste in the computer output that measures evidence for the claim there is a relationship between the variables “which version?” and “would you buy?” if you consider the whole population
b) Make suitable comments about the output in part (a)
c) paste in the output that gives two cases where each case is a summary that lets you see the relationship between the variable “which version?” and “would you buy?”




d) Consider the two cases in part c) which case would have the lower p value , give a reason for your answer
Question 7
Paste dataset 2 into the dataset summarizer
a) Paste in inferential statistics that measure evidence for the claim there is a relationship between the variables “which version?” and “How much would you pay?” if you consider the whole population
b) Make suitable comments about the output in part (a)
c) paste in the output that gives two cases where each case is a summary that lets you see the relationship between the variable “which version?” and “How much would you pay?”
d) Consider the two cases in part c) which case would have the lower p value , give a reason for your answer
Question 8
Paste dataset 3 into the dataset summarizer
a) Paste in computer output that measure evidence for the claim there is a relationship between the variables “change in income?” and “How much would you pay?” if you consider the whole population
Hint: inferential statistics measure evidence for a claim.
b) Make suitable comments about the output in part (a)
c) paste in the output that gives two cases where each case is a summary that lets you see the relationship between the variable “change in income?” and “how much would you pay?”
d) Consider the two cases in part c) which case would have the lower p value , give a reason for your answer
Question 9
Paraphrase the content of one or more of the videos and explain why statistics is useful in business . A total of 400 words is enough.
What is statistics
https://youtu.be/wG8L_C2OMu8?t=42
What is business statistics
https://youtu.be/klvvG3_MX6A
Statistics and the Application of Statistics in Business and Economics
https://youtu.be/KtoJdbWGGbg
Statistics made easy
https://youtu.be/I10q6fjPxJ0
P values and how to interpret them
https://youtu.be/vemZtEM63GY
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 dataset summarizer
However 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
A) 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) “which version?” and “would you buy?”
B) Select all of dataset 2 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 version?” and “How much would you pay?”
C) Select all of dataset 3 and use excel commands to make a graph that lets you investigate the relationship between the fields (variables) “Change an income?” and “How much would you pay?”
D) Upload the excel file with the pivot tables and scatterplot to the assignment dropbox
1
Answered 3 days AfterMay 10, 2021BUS105University of the Sunshine Coast

Solution

Anu Sirohi answered on May 14 2021
28 Votes

Submit New Assignment

Copy and Paste Your Assignment Here