Safari File Edit View History Bookmarks Window Help < > B+ Algoma Unive... - June 2022 Algoma Gmail Gmail P = + Moodle Dashboard Telegram M Algoma University Moodle 10 11 12 13 14 16 17 18 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 Finish attempt... Time left 1:35:00 THE CCC CASE: courses.algomau.ca BrightSpace Algoma University Linkdin Learning YouTube Microsoft Office Home TinyWow Telegram Web Spotify In FINAL EXAM ON 28 JULY 2022 Dashboard Thu Jul 28 9:54 AM + 88 Kunwar Dhawan A credit card company, CCC wanted to understand how its customers use their credit card, i.e. what types of purchase they use the credit card for and how frequent they use the card etc. The company, CCC has randomly selected a small sample from its customer database. The dataset consists of the following fields: Table 1: Dataset Fields (just a list of fields) Customer_ID Gender Birth_Date Ref_Date Marital Status Occupation_Category Total_Installments Airlines_Count Total_Transactions Appliances_Count Total_Amount Airlines_Amount Appliances_Amount Auto Moto_Count Auto Moto_Amount Beverages_Smoke_Count Beverages_Smoke_Amount Books_Music_Count Clothing Count Construction_Count Books_Music_Amount Clothing_Amount Construction_Amount Direct Marketing_Count Direct Marketing_Amount ht er Jer Education_Count Education_Amount Entertainment_Count Entertainment Amount iles Financial_Services_Count Financial_Services_Amount Fitness_Count Fitness_Amount Food_Count Food_Amount Gas_Count Gas_Amount Gifts_Accessories_Count Health_Count Gifts_Accessories_Amount Health_Amount Hits Safari File Edit View History Bookmarks Window Help < > B+ Algoma Unive... - June 2022 Algoma Gmail Gmail Moodle Dashboard Telegram M Algoma University Moodle courses.algomau.ca BrightSpace Algoma University Linkdin Learning YouTube Microsoft Office Home Tiny Wow Telegram Web Spotify In FINAL EXAM ON 28 JULY 2022 Dashboard Financial_Services_Count Financial_Services_Amount Fitness_Count Food_Count Gas_Count Fitness_Amount Food_Amount Gas_Amount Gifts_Accessories_Count Gifts_Accessories_Amount Hotels_Amount Industrial_Amount Health_Count Health_Amount Home_Count Home_Amount Hotels Count Industrial_Count Jewelry_Count Office_Count Optical_Count Payments_Count Jewelry_Amount Office_Amount Optical_Amount Payments_Amount Rent_Transportation_CountRent_Transportation_Amount Services_Count Telcos_Count Transportation_Count Travel_Count Services_Amount Telcos_Amount Transportation_Amount Travel_Amount Thu Jul 28 9:54 AM Kunwar Dhawan The data analyst has used the pivot table option in excel and produced the following summary tables for the Total_Amount field, see table 2a, b, c and d. Table 2a: Summary for the Sum of the Total_Amount (gender versus marital_status) + 88 ht er Jer iles M Safari File Edit View History Bookmarks Window Help < > B+ courses.algomau.ca Algoma Unive... - June 2022 Algoma Gmail Gmail Moodle Dashboard BrightSpace Algoma University Linkdin Learning YouTube Microsoft Office Home In FINAL EXAM ON 28 JULY 2022 Telegram TinyWow Telegram Web Spotify Dashboard Algoma University Moodle Table 2a: Summary for the Sum of the Total_Amount (gender versus marital_status) Female Male Grand Total Divorced 505.32 Married Single Widow 4354.07 1074.22 151.19 19021.06 505.32 23375.13 8971.38 10045.6 151.19 Grand Total 6084.8 27992.44 34077.24 Table 2b: Summary for the Count of the Total_Amount (gender versus marital_status) Female Male Grand Total Divorced 1 1 Married 7 14 21 Single 3 4 7 Widow 1 1 Grand Total 12 18 30 Thu Jul 28 9:54 AM Kunwar Dhawan + 88 ht er Jer iles Safari File Edit View History Bookmarks Window Help Thu Jul 28 9:54 AM < > B+ courses.algomau.ca + 88 Algoma Unive... - June 2022 Algoma Gmail Gmail M Algoma University Moodle Telegram Moodle Dashboard BrightSpace Algoma University Linkdin Learning YouTube Microsoft Office Home TinyWow Telegram Web Spotify In FINAL EXAM ON 28 JULY 2022 Dashboard Kunwar Dhawan Table 2c: Summary for the Variance of the Total_Amount (gender versus marital_status) Female Male Grand Total Divorced Married Single 397600.4597 3796370.421 2713535.577 127424.6785 3315939.532 2715405.869 Widow Grand Total 266016.7452 3631348.173 2502342.468 Table 2d: Possible t-value at 95% confidence level for each customer category Female Male Grand Total Divorced Married Single 2.446912 4.302653 2.160369 2.085963447 3.182446 2.446911851 Widow Grand Total 2.200985 2.109816 2.045229642 In addition, the analyst wanted to go deeper into the analysis and wanted to calculate more metrics to understand the cus behavior. The analyst accordingly produced the below table for some selected categories, see table 3. ht er Jer iles Safari File Edit View History Bookmarks Window Help Thu Jul 28 9:54 AM < > B+ courses.algomau.ca + 88 Algoma Unive... - June 2022 Algoma Gmail Gmail M Algoma University Moodle Telegram Moodle Dashboard BrightSpace Algoma University Linkdin Learning YouTube Microsoft Office Home Tiny Wow Telegram Web Spotify In FINAL EXAM ON 28 JULY 2022 Dashboard Kunwar Dhawan behavior. The analyst accordingly produced the below table for some selected categories, see table 3. Table 3: Descriptive Analysis for some selected categories ht Descriptive Metric Total_Amount Appliances Clothing Entertainment Fitness Food Health Telcos Sum 34077.24 6967.4 Total Variation 5984.32 586.38 779.15 624.72 72567931.58 7302091.642 5323442.163 335448.0715 43901.89 156393.6 261346.29 29077726.99 589.08 8972.55 er Minimum 22.8 0 0 0 0 0 Maximum 7178.26 2381.21 1848.36 589.08 139.22 329.46 511.38 4831.79 Jer Median 547.31 38.94 t-value at 95% CL 2.0452296422.0452296422.045229642 2.045229642 2.04523 2.04523|2.04522962.045229642 Benchmark First Quartile Third Quartile 1250 184.9775 1487.4425 500 150 60 60 60 50 700 0 0 0 0 42.75 237.6975 0 0 0 Moreover, the analyst wanted to figure out whether there are some associations among various categories. So, the following tables were produced, see table 4. Table 4: Linear Regression coefficients table for selected categories as independent variables versus the total_am the dependent variable. les M Safari File Edit View History Bookmarks Window Help < > B+ courses.algomau.ca Algoma Unive... - June 2022 Algoma Gmail Gmail Moodle Dashboard BrightSpace Algoma University Linkdin Learning YouTube Microsoft Office Home TinyWow Telegram Web Spotify In FINAL EXAM ON 28 JULY 2022 Telegram Algoma University Moodle Thu Jul 28 9:55 AM + 88 Dashboard Kunwar Dhawan Table 4: Linear Regression coefficients table for selected categories as independent variables versus the total_amount as the dependent variable. Variables Coefficient Standard Error t Stat p-value (Intercept) Appliances_Amount Books_Music_Amount -5.641 49.926 -0.1130.91083685 0.91 0.285 3.1890.00350119 4.29 1.281 3.35 0.002323 Clothing_Amount 0.993 0.154 6.4335.7544E-07 Direct Marketing_Amount 1.007 0.156 6.4435.6038E-07 Entertainment Amount -8.453 5.609 -1.5070.14301106 Fitness_Amount 3.685 1.263 2.9180.00687365 Food_Amount -0.739 0.876 -0.8440.40582279| Gas_Amount 13.584 7.213 1.883 0.07012785 Gifts Accessories Amount 1.316 0.672 1.959 0.06013942 Health_Amount 1.781 2.65 0.6720.50709119 Home_Amount 0.691 0.217 3.1910.00348353 Office_Amount 1.522 1.713 0.8890.38157728 Services_Amount 1.423 0.265 5.3711.0067E-05 Telcos_Amount 0.958 0.031 30.4555.2173E-23 Travel_Amount 0.965 0.373 2.5910.01502837 ht er Jer iles Safari File Edit View History Bookmarks Window Help Thu Jul 28 9:55 AM < > B+ courses.algomau.ca + 88 Algoma Unive... - June 2022 Algoma Gmail Gmail M Telegram Moodle Dashboard BrightSpace Algoma University Linkdin Learning YouTube Microsoft Office Home TinyWow Telegram Web Spotify In FINAL EXAM ON 28 JULY 2022 Dashboard Algoma University Moodle Kunwar Dhawan Question Not yet Based on the above tables, 2a, b, c and d, answer the following questions: answered The average total amount ($) for married female customers is: Marked out of 1.00 Flag question a. 151.19 b. 1113.101429 C. 358.0733 d. 622.01 Question 2 Not yet answered Marked out of 1.00 Flag question Based on the above tables, 2a, b, c and d, answer the following questions: The lower confidence limit for the mean of the total amount ($) at 95% confidence level for all customers is: a. 607.4981664 b. 545.2245206 c. 363.2679852 Question 3 Not yet answered Marked out of 1.00 Flag question d. 179.3632427 Based on the above tables, 2a, b, c and d, answer the following questions: The lower confidence limit for the mean of the total amount ($) at 95% confidence level for married male customers is: a. 233.6585 b. 607.4981664 c. 545.2245206 d. 363.2679852 ht er iles M Safari File Edit View History Bookmarks Window Help Thu Jul 28 9:55 AM < > B+ courses.algomau.ca + 88 Algoma Unive... - June 2022 Algoma Gmail Gmail Moodle Dashboard BrightSpace Algoma University Linkdin Learning YouTube Microsoft Office Home TinyWow Telegram Web Spotify Telegram In FINAL EXAM ON 28 JULY 2022 Dashboard Kunwar Dhawan Algoma University Moodle Question Not yet answered Marked out of 1.00 Flag question Based on the above tables, 2a, b, c and d, answer the following questions: The upper confidence limit for the mean of the total amount ($) at 95% confidence level for married customers is: a. 1862.934872 b. 1205.176735 c. 1726.591479 d. 2483.635792 Question 5 Not yet answered Marked out of 1.00 Flag question Based on the above tables, 2a, b, c and d, answer the following questions: The average total amount ($) for single customers is: a. 151.19 b. 1435.085714 c. 358.0733 d. 1113.101429 Question 6 Not yet answered Marked out of Based on the above tables, 2a, b, c and d, answer the following questions: The average total amount ($) for male customers is: 1.00 Flag question a. 1435.085714 b. 1358.647 c. 2242.845 d. 1555.136 ht er Jer iles Safari File Edit View History Bookmarks Window Help Thu Jul 28 9:55 AM < > B+ courses.algomau.ca + 88 Algoma Unive... - June 2022 Algoma Gmail Gmail Moodle Dashboard BrightSpace Algoma University Linkdin Learning YouTube Microsoft Office Home TinyWow Telegram Web Spotify M Telegram In FINAL EXAM ON 28 JULY 2022 Dashboard Algoma University Moodle Kunwar Dhawan Question Based on the above tables, 2a, b, c and d, answer the following questions: Not yet answered The average total amount ($) for widow female customers is: Marked out of 1.00 Flag question a. 358.0733333 b. 622.01 c. 151.19 d. 507.0666667 Question 8 Not yet answered Marked out of 1.00 Flag question Based on the above tables, 2a, b, c and d, answer the following questions: The standard deviation for the total amount ($) for single female customers is: a. 630.5557 b. 515.7681118 c. 356.9659 O d. 1647.848861 Question 9 Not yet answered Marked out of Based on the above tables, 2a, b, c and d, answer the following questions: The standard deviation for the total amount ($) for all customers is: 1581.87941 1.00 Flag question a. 1948.428 b. 1581.87941 c. 1820.972 d. 1647.281268 ht er Jer iles Safari File Edit View History Bookmarks Window Help < > B+ Algoma Unive... - June 2022 Algoma Gmail Gmail Telegram M Algoma University Moodle courses.algomau.ca Moodle Dashboard BrightSpace Algoma University Linkdin Learning YouTube Microsoft Office Home TinyWow Telegram Web Spotify In FINAL EXAM ON 28 JULY 2022 Question O Based on the above tables, 2a, b, c and d, answer the following questions: Not yet answered The standard deviation for the total amount ($) for married male customers is: Marked out of 1.00 Flag question a. 1948.428 b. 1647.281268 c. 1820.972 d. 1647.848861 Thu Jul 28 9:55 AM Dashboard Kunwar Dhawan + 88 ht er Question 11 Not yet answered Based on the above tables, 2a, b, c and d, answer the following questions: The standard deviation for the total amount ($) for married customers is: Jer Marked out of 1.00 Flag question a. 1820.972 b. 1647.281268 c. 1647.848861 O d. 1948.428 Question 12 Based on the above tables, 2a, b, c and d, answer the following questions: The upper confidence limit for the mean of the total amount ($) at 95% confidence level for single female customers is: Not yet answered Marked out of 1.00 a. 1244.826 Flag question b. 1205.176735 C. 505.32 d. 834.7700906 iles Safari File Edit View History Bookmarks Window Help < > B+ Algoma Unive... - June 2022 Algoma Gmail Gmail Telegram M Algoma University Moodle courses.algomau.ca Moodle Dashboard BrightSpace Algoma University Linkdin Learning YouTube Microsoft Office Home TinyWow Telegram Web Spotify In FINAL EXAM ON 28 JULY 2022 Question 13 Not yet Based on given values in table 3, answer the following questions: The standard deviation for the total_amount ($) is: answered Marked out of 1.00 Flag question a. 2502342.468 b. 72567931.58 c. 1581.87941 O d. 34077.24 Question 14 Not yet answered Marked out of 1.00 Flag question Based on given values in table 3, answer the following questions: The value for the telcos_amount ($) given its z-score = -0.25, is: a. 139.4880548 b. 326.0937888 c. 48.75019404 O d. 549.419806 Question 15 Not yet answered Marked out of 1.00 Flag question Based on given values in table 3, answer the following questions: The coefficient of variation for the appliances_amount ($) is: a. 251.55% b. 72567931.58% C. 501.7930485% d. 91.61445728% Thu Jul 28 9:55 AM Dashboard Kunwar Dhawan + 88 ht er Jer les Safari File Edit View History Bookmarks Window Help < > B+ Algoma Unive... - June 2022 Algoma Gmail Gmail Telegram M Algoma University Moodle courses.algomau.ca Moodle Dashboard BrightSpace Algoma University Linkdin Learning YouTube Microsoft Office Home TinyWow Telegram Web Spotify In FINAL EXAM ON 28 JULY 2022 Question 16 Not yet answered Based on given values in table 3, answer the following questions: The standard error for the clothing_amount ($) is: Marked out of 1.00 Flag question a. 1848.36 b. 38.94 c. 159.9847998 d. 78.22339189 Question 17 Not yet answered Marked out of 1.00 Based on given values in table 3, answer the following questions: The margin of error at 95% confidence level for the entertainment_amount ($) is: a. 7.103657235 Flag question b. 78.22339189 c. 40.16012925 d. 19.636 Question 18 Not yet answered Marked out of 1.00 Flag question Based on given values in table 3, answer the following questions: The upper confidence interval for the mean of fitness_amount ($) at 95% confidence level is: a. 34.07461 b. 40.16012925 c. 19.546 d. 38.90833308 Thu Jul 28 9:55 AM + 88 Dashboard Kunwar Dhawan ht er er g iles Safari File Edit View History Bookmarks Window Help Thu Jul 28 9:55 AM < > B+ courses.algomau.ca + 88 Algoma Unive... - June 2022 M Algoma University Moodle Algoma Gmail Gmail Telegram Moodle Dashboard BrightSpace Algoma University Linkdin Learning YouTube Microsoft Office Home TinyWow Telegram Web Spotify In FINAL EXAM ON 28 JULY 2022 Dashboard Kunwar Dhawan Question 19 Not yet answered Based on given values in table 3, answer the following questions: The z-score for the 2nd quartile of the total_amount ($) is: Marked out of 1.00 Flag question a. -0.372087781 b. -0.182574186 c. -0.45117971 d. -0.397529089 Question 20 Not yet answered Marked out of 1.00 Flag question Based on given values in table 3, answer the following questions: The value for the food_amount ($) given its z-score = 1.25, is: a. 3113.257263 b. 117.767 c. 139.4880548 d. 68.18141636 Question 21 Based on given values in table 3, answer the following questions: Not yet answered Marked out of 1.00 Flag question Based on the given quartile values for the total_amount ($), we can conclude that: a. there is no outlier in the total_amount but there is in the rest of the data b. there is no outlier in the data c. there is at least one outlier in the data d. there is at most one outlier in the data ht er Jer les Hits M Safari File Edit View History Bookmarks Window Help < > B+ courses.algomau.ca Algoma Unive... - June 2022 Algoma Gmail Gmail Telegram Moodle Dashboard BrightSpace Algoma University Linkdin Learning YouTube Microsoft Office Home In FINAL EXAM ON 28 JULY 2022 Algoma University Moodle Question 22 Not yet answered Marked out of 1.00 Flag question d. there is at most one outlier in the data TinyWow Telegram Web Spotify Dashboard Thu Jul 28 9:56 AM Kunwar Dhawan + 88 Based on given values in table 3, answer the following questions: At the given value of the benchmark for the health_amount ($), we can conclude that: a. the health_amount mean ($) is within the benchmark at 95% confidence level b. the health_amount ($) is within the benchmark at 95% confidence level c. the health_amount mean ($) is significantly lower than the benchmark at 95% confidence level d. the health_amount mean ($) is significantly higher than the benchmark at 95% confidence level Question 23 Not yet answered Marked out of 1.00 Flag question Based on the given values in table 4, answer the following questions: Comparing the Entertainment, Food, Gas and Health categories, the conclusion is: a. Entertainment category is significantly contributing in the total_amount ($) while the Food, Gas and Health categories, are not significantly contributing in the total amount ($) b. Entertainment, Food, Gas and Health categories, are not significantly contributing in the total amount ($) c. Entertainment and Food categories are significantly contributing in the total_amount ($) while the Gas and Health categories, are not significantly contributing in the total amount ($) d. Food category is significantly contributing in the total_amount ($) while the Entertainment, Gas and Health categories, are not significantly contributing in the total amount ($) Question 24 Not vet Based on the given values in table 4, answer the following questions: ht er Jer iles Hits M Safari File Edit View History Bookmarks Window Help Thu Jul 28 9:56 AM < > B+ courses.algomau.ca + 88 Algoma Unive... - June 2022 Algoma Gmail Gmail Moodle Dashboard BrightSpace Algoma University Linkdin Learning YouTube Microsoft Office Home TinyWow Telegram Web Spotify Telegram In FINAL EXAM ON 28 JULY 2022 Dashboard Algoma University Moodle Kunwar Dhawan Food Category is significantly contributing in the total_amount ($) while the Entertaiment, Gas and Health categories, are not significantly contributing in the total amount ($) Question 24 ht Based on the given values in table 4, answer the following questions: Not yet answered Comparing appliances, books & music, clothing and telcos categories, the conclusion is: Marked out of 1.00 Flag question a. Books & music category is not significantly contributing in the total_amount ($), while, appliances, clothing and telcos categories are significantly contributing in the total amount ($). b. Appliances category is not significantly contributing in the total_amount ($), while books & music, clothing and telcos categories are significantly contributing in the total amount ($). er c. Appliances, books & music, clothing and telcos categories are significantly contributing in the total amount ($). Jer d. Appliances and books & music categories are not significantly contributing in the total_amount ($), while clothing and telcos categories are significantly contributing in the total amount ($). Question 25 Not yet answered Marked out of 1.00 Flag question Based on the given values in table 4, answer the following questions: The analyst concluded that the most significant contribution to the total amount comes from a. Services category. b. Gas category. c. Books & Music category. d. Telcos category. Question 26 Based on the given values in table 4, answer the following questions: iles Safari File Edit View History Bookmarks Window Help < > Algoma Unive... - June 2022 M Algoma University Moodle B+ courses.algomau.ca Algoma Gmail Gmail Moodle Dashboard BrightSpace Algoma University Linkdin Learning YouTube Microsoft Office Home TinyWow Telegram Web Spotify Telegram d. Telcos category. In FINAL EXAM ON 28 JULY 2022 Thu Jul 28 9:56 AM + 88 Dashboard Kunwar Dhawan Question 26 Not yet answered Based on the given values in table 4, answer the following questions: The analyst concluded that: Marked out of 1.00 a. By increasing the amount of fitness category by one dollar, the total amount ($) will increase by 3.685 dollars. Flag question b. By increasing the amount of fitness category by one dollar, the total amount ($) will increase by 3.685 dollars in addition to $5.641. c. By increasing the amount of fitness category by one dollar, the total amount ($) will decrease by 3.685 dollars. d. By increasing the amount of fitness category by one dollar, the total amount ($) will not be affacted. Question 27 Based on the given values in table 4, answer the following questions: Not yet answered The analyst concluded that: Marked out of 1.00 Flag question a. By increasing the amount of gas category by one dollar, the total amount will change by an insignificant amount of $13.584. b. By increasing the amount of gas category by one dollar, the total amount will decrease by 13.584 dollars. c. By increasing the amount of gas category by one dollar, the total amount will increase by 13.584 dollars in addition to $ 5.641. d. By increasing the amount of gas category by one dollar, the total amount will increase by 13.584 dollars. Question 28 Not yet You are given the descriptive statistics for a dataset such as: Median (6983.43), Mode (.), Sample Variance (1573128.64), (-0.76), Skewness (0.08), Sum (1389620.69), Count (200), t-value at 95% CL (1.972). The Lower limit for the mean at 95! ht er ler les