Please note: the table below can also be downloaded as an excel file at the foll
ID: 3209131 • Letter: P
Question
Please note: the table below can also be downloaded as an excel file at the following link:
https://dl.dropboxusercontent.com/u/98580432/Chegg%20question%20excel%20file%20-%20.xlsx
a) Determine what type of sampling method should be used to develop the survey (random, systematic, cluster, stratified). If more than one method can be used, describe each one.
b) Determine the level of measurement (nominal, ordinal, interval, ratio) and type of data (discrete or continuous) for each variable.
c) Create a frequency table for province and a frequency table for gender. Explain what your tables show.
d) Create a frequency table for purchase amount using the following classes ($100 to under $200, $200 to under $300, $300 to under $400, $400 to under $500, $500 to under $600).
- What percent of customers spend between $200 to under $300 (round to 2 decimals)?
- What class has the most purchases?
- What percent of customers spend less than $400?
e) Create a histogram for monthly purchase. Describe what you see (shape, outliers).
f/g) Use the five-number summary to draw a boxplot for this data. (Label the five values on the boxplot)
Gender Age Monthly Purchase Province Household Income 1 F 26 $ 385.66 Manitoba $150,000 to under $200,000 2 F 19 $ 336.80 Ontario $100,000 to under $150,000 3 F 29 $ 399.23 BC $0 to under $50,000 4 F 26 $ 239.99 Ontario $0 to under $50,000 5 M 36 $ 401.11 BC $0 to under $50,000 6 F 45 $ 467.48 Ontario $100,000 to under $150,000 7 F 19 $ 345.67 Quebec $0 to under $50,000 8 M 21 $ 416.71 Manitoba $100,000 to under $150,000 9 F 33 $ 219.80 BC $50,000 to under $100,000 10 M 26 $ 460.58 Quebec $50,000 to under $100,000 11 M 28 $ 142.79 Ontario $100,000 to under $150,000 12 F 46 $ 449.16 Manitoba $100,000 to under $150,000 13 M 21 $ 332.81 Alberta $0 to under $50,000 14 F 21 $ 498.18 BC $150,000 to under $200,000 15 M 46 $ 349.80 BC $150,000 to under $200,000 16 F 39 $ 315.10 Quebec $100,000 to under $150,000 17 M 39 $ 499.96 Alberta $50,000 to under $100,000 18 F 37 $ 419.22 Alberta $100,000 to under $150,000 19 M 31 $ 390.99 Ontario $0 to under $50,000 20 F 44 $ 399.66 Manitoba $100,000 to under $150,000 21 F 23 $ 494.66 Manitoba $100,000 to under $150,000 22 M 26 $ 375.20 BC $100,000 to under $150,000 23 F 29 $ 149.96 BC $50,000 to under $100,000 24 M 31 $ 401.12 Alberta $150,000 to under $200,000 25 F 40 $ 483.23 BC $100,000 to under $150,000 26 M 41 $ 419.33 Manitoba $100,000 to under $150,000 27 F 45 $ 280.98 Ontario $100,000 to under $150,000 28 M 22 $ 307.62 Manitoba $150,000 to under $200,000 29 F 44 $ 156.77 Alberta $0 to under $50,000 30 F 29 $ 357.87 Quebec $50,000 to under $100,000 31 F 31 $ 498.80 Manitoba $100,000 to under $150,000 32 F 23 $ 322.35 Manitoba $0 to under $50,000 33 M 22 $ 479.92 Quebec $150,000 to under $200,000 34 F 32 $ 322.49 Alberta $50,000 to under $100,000 35 F 37 $ 501.12 BC $50,000 to under $100,000 36 F 20 $ 261.32 Manitoba $0 to under $50,000 37 M 36 $ 294.26 BC $100,000 to under $150,000 38 F 18 $ 144.25 Alberta $50,000 to under $100,000 39 F 27 $ 478.21 Quebec $50,000 to under $100,000 40 F 32 $ 404.23 Quebec $150,000 to under $200,000 41 M 37 $ 461.65 Quebec $50,000 to under $100,000 42 M 46 $ 165.79 Ontario $150,000 to under $200,000 43 M 39 $ 343.12 Manitoba $100,000 to under $150,000 44 F 29 $ 397.58 BC $0 to under $50,000 45 M 42 $ 505.12 Quebec $150,000 to under $200,000 46 M 36 $ 443.12 Alberta $150,000 to under $200,000 47 M 27 $ 202.37 BC $50,000 to under $100,000 48 F 23 $ 574.22 BC $100,000 to under $150,000 49 F 45 $ 346.95 Quebec $50,000 to under $100,000 50 M 42 $ 392.82 Manitoba $150,000 to under $200,000 51 M 18 $ 437.71 Alberta $0 to under $50,000 52 M 33 $ 485.30 Manitoba $150,000 to under $200,000 53 F 25 $ 284.83 Ontario $0 to under $50,000 54 F 18 $ 112.94 Alberta $0 to under $50,000 55 F 34 $ 345.29 Alberta $150,000 to under $200,000 56 F 43 $ 127.14 Manitoba $0 to under $50,000 57 F 39 $ 189.44 Manitoba $50,000 to under $100,000 58 F 21 $ 208.19 BC $0 to under $50,000 59 F 27 $ 221.16 Ontario $0 to under $50,000 60 M 29 $ 367.73 Alberta $150,000 to under $200,000 61 F 35 $ 213.35 Manitoba $0 to under $50,000 62 M 35 $ 466.67 Alberta $150,000 to under $200,000 Mean $ 353.18 Median $ 371.47 StDev.S $ 116.40 Stdev.P $ 115.45 Lower Upper SD1 $ 237.72 SD1 $ 468.63 SD2 $ 122.27 SD2 $ 584.08 SD3 $ 6.82 SD3 $ 699.53 Q1 $ 281.94 Q3 $ 447.65 IQR $ 165.71 Outliers Lower limit $ 33.38 Upper limit $ 696.21 You were recently hired at a start-up company whose head office is in Mississauga. This company has 14 physical locations throughout Canada; six in Ontario, four in British Columbia, one in Alberta, one in Manitoba, and two in Quebec. The products this company sells are targeted at people between the ages of 25 and 45. Your first task in your new job is to design, distribute and summarize the results of a survey. The goal of the survey is to better understand your customers. The survey should collect customer information such as gender, age, amount purchased purchase location, and household income.Explanation / Answer
a)random: Random sampling can be done for understanding the customers better. This way we can actually understand different customers
Stratified: For this sampling we can do stratified sampling based on age such that we dont miss out any age's proportion of people which might happen in random sampling
cluster sampling can be biased for our case
systematics sampling can also be done for understinading the customers better
b)Gender and province are nominal,household income and age are ordinal,monthly purchase is interval
c)
d)
Row Labels Count of Monthly Purchase Alberta 13 BC 14 Manitoba 16 Ontario 9 Quebec 10 Grand Total 62Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.