Use this following as the cover page for the word file

“Title: semester 2, 2020 BUS105 computing assignment”

“Name:”

“Student number:”

“Sample: ”

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

“Instructions for the computing assignment worth 20% 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 students , each student must follow the instructions and get 3 datasets using their student number , each student will have different datasets

*An automatic dataset summarizer.

*Instructions for checking that you have properly found your sample, students must use their sample.

Students must submit a word file AND an excel file to moodle

¬*The word file needs to be submitted to the Turnitin link, the word file needs a cover page and the answers to 10 questions given in full detail later in this document (pages 2 to 6) 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 students 3 datasets and summaries NOT made by the automatic dataset summarizer students need to summarize the dataset using PivotTables and the scatterplot. Instructions for submitting the excel file are given on page 7“

“Instructions for the 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 10 questions the first 8 are about the dataset the last question is a paraphrasing task (refer to pages 3 to 6)

You will use your dataset and the automatic dataset summarizer to get the descriptive statistics that are used 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)

The word count can be less than 1500 words if you are giving answers that demonstrate you have understood the material.

Summary of the datasets (question 1 to 8 given on pages 3 to 6 are about the datasets)

Dataset 1

University XYZ gives out a survey to students in a statistics course

The survey questions were

Do you think the course is useful and do you understand why?

How many videos have you watched ?

The questions and the students’ answers are a dataset

Dataset 2

University XYZ gives out a survey to students in a statistics course

The survey questions were

What style of Youtube video do you prefer, chatty or direct ?

Are you scared of maths

How many videos did you watch ?

The questions and the students’ answers are a dataset

Dataset 3

Business XYZ is using videos to replace meetings to maintain social distancing

The duration of the video (in seconds) and engagement score is recorded for many videos

The engagement score is low if people only watch the first part of the video. “

Question 1

Paste dataset 1 into 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 “course useful?” and “number of videos watched ?” using the sample

b) Use the output in part (a) to describe the relationship between the two variables, your discussion must use one of the following sample statistics (choose one)

Difference between sample means? x ¯?_1 -? x ¯?_2

Difference between sample proportions ? p ^?_1 -? p ^?_2

correlation coefficient r

Question 2

Paste dataset 2 into 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 “Preferred style?” and “Scared of maths?” using the sample

b) Use the output in part (a) to describe the relationship between the two variables, your discussion must use one of the following sample statistics (chose one)

Difference between sample means? x ¯?_1 -? x ¯?_2

Difference between sample proportions ? p ^?_1 -? p ^?_2

correlation coefficient r

Question 3

Paste dataset 3 into the dataset summarizer

a) Paste in the descriptive sample statistics and the scatterplot into the word file. The descriptive statistics let you investigate the relationship between the variables “Duration?” and “Engagement score?” using the sample

b) Use the output in part (a) to describe the relationship between the two variables, your discussion must use one of the following sample statistics

Difference between sample means? x ¯?_1 -? x ¯?_2

Difference between sample proportions ? p ^?_1 -? p ^?_2

correlation coefficient r

c) Predict the engagement score of a video with duration 600.

Question 4

Use the output for question 1a

Just considering the people that do not find the course useful find the zscore of the sample mean if you assume the population mean is µ=5 and the population standard deviation is s=3

Just considering the people that do find the course useful find the zscore of the sample mean if you assume the population mean is µ=5 and the population standard deviation is s=3

Question 5

Just considering the people that prefer the chatty style of video find a 90% confidence interval for the proportion of people that are scared of maths

Just considering the people that prefer the direct style of video find a 90% confidence interval for the proportion of people that are scared of maths

Question 6

Paste dataset 1 into the dataset summarizer

a) Paste in inferential statistics that measure evidence for the claim there is a relationship between the variables “course useful?” and “number of videos watched ?” if you consider the whole population

b) Make suitable comments about the output in part (a)

c) Go back to the dataset summarizer and scroll down , Paste in the output for question 6c given below the inferential statistics and fill in the blank , replace the blank with a number that would make the p-value lower than the p-value in question 6a

Question 7

Paste dataset 2 into the dataset summarizer

a) Paste in computer output that measure evidence for the claim there is a relationship between the variables “preferred style ?” and “scared of Maths?” 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) Go back to the dataset summarizer and scroll down , Paste in the output for question 7c given below the inferential statistics and fill in the blanks, you have to replace the blanks with numbers that give a smaller p-value than the p-value in question 7a , Note that the total of blanks must also agree with the existing total as well.

Question 8

Paste dataset 3 into the dataset summarizer

a) Paste in computer output that measures evidence for the claim there is a relationship between the variables “Duration?” and “engagement score?” 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) If another sample had a higher correlation would you expect the pvalue to be lower or higher ?

Question 9

Briefly discuss the sample report given in the link below 300 words is enough , in particular discuss the dataset , how the data was analysed and the main message of the report

https://app.box.com/s/lr3nmaozfgaxf7r4mq1quw5m69v20s3m

(you need to click download, logging in will not work) and discuss how it is communicated. Do not cut and paste text and use a computer to randomly change the words

Question 10

Give a quick comment about the discussion of p-values given in the link below, 300 words is enough.

https://app.box.com/s/mnbbg5gn4e10ysetgg0t94psw1nzo141

For each case discuss the relationship between p-value and the percentile of p-value (in other words discuss the distribution of p-value). Note that in the first case discussed there is a large difference in population means so there is a strong relationship in the population, how would you describe the distribution of p-value? In the second case there is almost no difference between the means so there is almost no relationship, how would you describe the distribution of p-value ?

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 4 instructions below, DO NOT use a cover page for the excel file, you must check that you have the correct sample

Note that you can still do this at home even if you do not have excel, just 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) “course useful?” and “number of videos watched?”

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) “preferred style?” and “scared of maths?”

Select all of dataset 3 and use excel commands to make a graph that lets you investigate the relationship between the fields (variables) “duration?” and “engagement score?”

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

“Title: semester 2, 2020 BUS105 computing assignment”

“Name:”

“Student number:”

“Sample: ”

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

“Instructions for the computing assignment worth 20% 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 students , each student must follow the instructions and get 3 datasets using their student number , each student will have different datasets

*An automatic dataset summarizer.

*Instructions for checking that you have properly found your sample, students must use their sample.

Students must submit a word file AND an excel file to moodle

¬*The word file needs to be submitted to the Turnitin link, the word file needs a cover page and the answers to 10 questions given in full detail later in this document (pages 2 to 6) 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 students 3 datasets and summaries NOT made by the automatic dataset summarizer students need to summarize the dataset using PivotTables and the scatterplot. Instructions for submitting the excel file are given on page 7“

“Instructions for the 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 10 questions the first 8 are about the dataset the last question is a paraphrasing task (refer to pages 3 to 6)

You will use your dataset and the automatic dataset summarizer to get the descriptive statistics that are used 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)

The word count can be less than 1500 words if you are giving answers that demonstrate you have understood the material.

Summary of the datasets (question 1 to 8 given on pages 3 to 6 are about the datasets)

Dataset 1

University XYZ gives out a survey to students in a statistics course

The survey questions were

Do you think the course is useful and do you understand why?

How many videos have you watched ?

The questions and the students’ answers are a dataset

Dataset 2

University XYZ gives out a survey to students in a statistics course

The survey questions were

What style of Youtube video do you prefer, chatty or direct ?

Are you scared of maths

How many videos did you watch ?

The questions and the students’ answers are a dataset

Dataset 3

Business XYZ is using videos to replace meetings to maintain social distancing

The duration of the video (in seconds) and engagement score is recorded for many videos

The engagement score is low if people only watch the first part of the video. “

Question 1

Paste dataset 1 into 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 “course useful?” and “number of videos watched ?” using the sample

b) Use the output in part (a) to describe the relationship between the two variables, your discussion must use one of the following sample statistics (choose one)

Difference between sample means? x ¯?_1 -? x ¯?_2

Difference between sample proportions ? p ^?_1 -? p ^?_2

correlation coefficient r

Question 2

Paste dataset 2 into 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 “Preferred style?” and “Scared of maths?” using the sample

b) Use the output in part (a) to describe the relationship between the two variables, your discussion must use one of the following sample statistics (chose one)

Difference between sample means? x ¯?_1 -? x ¯?_2

Difference between sample proportions ? p ^?_1 -? p ^?_2

correlation coefficient r

Question 3

Paste dataset 3 into the dataset summarizer

a) Paste in the descriptive sample statistics and the scatterplot into the word file. The descriptive statistics let you investigate the relationship between the variables “Duration?” and “Engagement score?” using the sample

b) Use the output in part (a) to describe the relationship between the two variables, your discussion must use one of the following sample statistics

Difference between sample means? x ¯?_1 -? x ¯?_2

Difference between sample proportions ? p ^?_1 -? p ^?_2

correlation coefficient r

c) Predict the engagement score of a video with duration 600.

Question 4

Use the output for question 1a

Just considering the people that do not find the course useful find the zscore of the sample mean if you assume the population mean is µ=5 and the population standard deviation is s=3

Just considering the people that do find the course useful find the zscore of the sample mean if you assume the population mean is µ=5 and the population standard deviation is s=3

Question 5

Just considering the people that prefer the chatty style of video find a 90% confidence interval for the proportion of people that are scared of maths

Just considering the people that prefer the direct style of video find a 90% confidence interval for the proportion of people that are scared of maths

Question 6

Paste dataset 1 into the dataset summarizer

a) Paste in inferential statistics that measure evidence for the claim there is a relationship between the variables “course useful?” and “number of videos watched ?” if you consider the whole population

b) Make suitable comments about the output in part (a)

c) Go back to the dataset summarizer and scroll down , Paste in the output for question 6c given below the inferential statistics and fill in the blank , replace the blank with a number that would make the p-value lower than the p-value in question 6a

Question 7

Paste dataset 2 into the dataset summarizer

a) Paste in computer output that measure evidence for the claim there is a relationship between the variables “preferred style ?” and “scared of Maths?” 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) Go back to the dataset summarizer and scroll down , Paste in the output for question 7c given below the inferential statistics and fill in the blanks, you have to replace the blanks with numbers that give a smaller p-value than the p-value in question 7a , Note that the total of blanks must also agree with the existing total as well.

Question 8

Paste dataset 3 into the dataset summarizer

a) Paste in computer output that measures evidence for the claim there is a relationship between the variables “Duration?” and “engagement score?” 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) If another sample had a higher correlation would you expect the pvalue to be lower or higher ?

Question 9

Briefly discuss the sample report given in the link below 300 words is enough , in particular discuss the dataset , how the data was analysed and the main message of the report

https://app.box.com/s/lr3nmaozfgaxf7r4mq1quw5m69v20s3m

(you need to click download, logging in will not work) and discuss how it is communicated. Do not cut and paste text and use a computer to randomly change the words

Question 10

Give a quick comment about the discussion of p-values given in the link below, 300 words is enough.

https://app.box.com/s/mnbbg5gn4e10ysetgg0t94psw1nzo141

For each case discuss the relationship between p-value and the percentile of p-value (in other words discuss the distribution of p-value). Note that in the first case discussed there is a large difference in population means so there is a strong relationship in the population, how would you describe the distribution of p-value? In the second case there is almost no difference between the means so there is almost no relationship, how would you describe the distribution of p-value ?

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 4 instructions below, DO NOT use a cover page for the excel file, you must check that you have the correct sample

Note that you can still do this at home even if you do not have excel, just 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) “course useful?” and “number of videos watched?”

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) “preferred style?” and “scared of maths?”

Select all of dataset 3 and use excel commands to make a graph that lets you investigate the relationship between the fields (variables) “duration?” and “engagement score?”

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

Subject Title Service and Experience ManagementSubject Code HOS302AAssessment Title ReportGraduate Capabilities Professional Expertise Innovative Problem Solving Skilled Collaboration Global CitizenshipAgile...• Assessment Two - Case ReportAssessment item 2 - Case Study ReportValue:50%Due Date:07-Oct-2022Return Date:28-Oct-2022Length:1800Submission method options: Alternative submission methodTask:In this assessment...MGMT2000 – Assessment 3, Part 2 Individual report task sheet and structureAssessment: Individual reportItem to be submitted: Individual reportWhere to submit: Turnitin portal under Assessment tab on Blackboard.(We...PUBH 6030 Public Health Protection and ControlAssessment 2 Team Policy Briefing (Oral Presentation)Task: Present a team policy briefing for a new National Health Minister to address an emerging challenge...OPM 220 Assignment #1 - Interview a Department Head ReportReport due: Oct 11, 2022Deliverable #2: Written Report 8-15 pagesAnalysis of Hotel Department Management Below:Sheraton Parkway, Richmond Hill...TaskThe task is to undertake a simulation (role-play) of the business decision-making process. This simulation is to be completed and submitted individually, however students will collaborate on some parts...Activity Submission 4Do some investigation on the Internet and look for a company that is utilizing Business Analytics in an interesting way. Write a brief report on this company and how it is using analytics...**Show All Questions**