“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...

its in the file attached


“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 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