Statistics Research - Company XYZ Dataset Lurking Variables - Report Writing Assessment Answer

Download Solution Order New Solution
Internal Code: E_AI_DIEI_BHA

Statistics Research Report Writing Assessment Answer

Assignment Task: Dataset overview Suppose market research company XYZ shows potential buyers two versions of a laptop and asks them how much they would pay for version 1 and version 2.   Some of the buyers come from region A and some come from region B, for example region A could be Sydney and region B could be outside of Sydney. A dataset showing you the buyers answers is given on moodle The variables of the data set are: “Which region? Region A (A) or Region B (B)” “How much would you pay for version 1?” “How much would you pay for version 2?” “Would you pay more for version 1? Yes (y) or No (n)” The columns “student number” and “which sample” are variables they are used to give every student their own sample Task overview   You need to submit discussion of your dataset as a word file, You also need to submit an excel file that shows you can summarize the dataset without using the automatic dataset summarizer and p-value calculator. Instructions explaining how to discuss the dataset in a word file  
  1. Use the automatic dataset summarizer to make a summary that lets you investigate the relationship between the variables “Which region?” and “How much would they pay for version 1?”.  Paste the summary into the word file. Briefly comment on the relationship between the variables.
  2. Use the automatic dataset summarizer  to make to Make a graph that lets you investigate the relationship between the variables  “How much they would pay for version 1” and “How much would they pay for version 2” and paste it into the word file . Briefly comment on the relationship between the variables.
  3. Use the automatic dataset summarizer to make a summary that lets you investigate you investigate the relationship between the variables “Which region?” and “would you pay more for version 1” and paste the summary into the word file. Briefly comment on the relationship between the variables.
  4. Find a 95% confidence interval for the variable “would you pay more for version 1”
  5. Find the test stat for testing the claim that people would pay more than $1000 for version 1 on average.
This is the same as finding the zscore for the sample mean if you assume the population mean is 1000 and the population standard deviation is the same as the population standard deviation. To this question you need to find the sample size, mean and standard deviation of the variable “how much would you pay for version 1”, This is not difficult you can either use the =count(), =average() and =stdev() command, you would also get the relevant information when you do part (b) of the excel task.  
  1. Test the claim there is a relationship between the variables “Which region?” and “How much would they pay for version 1?”. Use the automatic dataset summarizer to get the p-value. Interpret the p-value in simple terms.  You are not required to discuss H0 and H1.
  2. Test the claim there is a relationship between the variables “Which region?” and “Would they pay more for version 1?”. Use the automatic dataset summarizer to get the p-value. Use the automatic dataset summarizer to get the p-value. Interpret the p-value in simple terms you are not required to discuss H0 and H1.
  3. Briefly describe some other variables that could be used in a dataset if you wanted to help a business that makes laptops and explain why the variables would be useful. 
  4. Briefly describe what is meant by the phrase “lurking variables” and explain why it is important to consider lurking variables when writing a report.
Instructions for the excel file, demonstrate you can make summaries without using the automatic dataset summarizer
  1. Paste in your dataset into the excel file
  2. Use a pivot table to make a summary that lets you investigate the relationship between the variables “Which region?” and “How much would they pay for version 1”
  3. Make a graph that lets you investigate the relationship between the variables “How much they would pay for version 1” and “How much would they pay for version 2”.
  4. Use a pivot table to make a summary that lets you investigate the relationship between the variables “Which region?” and “would you pay more for version 1”
This Statistics Research Report Writing Assessment has been solved by our Report Writing experts at onlineassignmentbank. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Get It Done! Today

Country
Applicable Time Zone is AEST [Sydney, NSW] (GMT+11)
+

Every Assignment. Every Solution. Instantly. Deadline Ahead? Grab Your Sample Now.