Statistics help needed. Test was taken and failed miserably. Any help is greatly appreciated.

~ (usernam Attempt 1 Written: Oct 2, 2018 5:37 PM - Oct 2, 2018 5:52 PM Submission View Your quiz has been submitted successfully. Lesson 8 Exam Question 1 Suppose the goal of data mining using this data warehouse was to predict whether a household's telecommunication needs will increase, decrease, or stay the same over the next year. What technique might be most appropriate for achieving this goal? Question options: f\" Terminal model 4\" Network model 5" Tree model ' f\" Neural model Question 2 What affects flat panel LCD TV sales? Flat panel LCD TVs are sold through a variety of outlets. Sales figures (number of units) for the popular Sony Bravia were obtained for last quarter from a sample of 30 different stores. Also collected were data on the selling price and amount spent on advertising the Sony Bravia (as a percentage of total advertising expenditure in the previous quarter) at each store. The results are shown below. Dependent Variable ls Turnover Rate 5 = 10.6075 R-Sq = 84.4% R-Sq(adj) = 83.3% Predictor Coef SE Coef T P The correct interpretation of the Constant 90-19 7-5-08 3-50 0-001 regression coefcient for Advertising Price -0.03055 0.01005 -3.04 0.005 '5: Question options: Advertising 3.0926 0.3680 8.40 0.000 1... while price negatively affects the number of Sony Bravia LCD TVs sold, an increase in the amount of money spent on advertising will result in at least 3 additional TVs sold. If\" at a given price, increasing the amount spent on advertising the Sony Bravia over the previous quarter will increase sales by 3.0926 units, on average. a one percent increase in the amount spent on advertising the Sony Bravia over the previous quarter will increase sales by 3.0926 units, on average. G\" at a given price, a one percent increase in the amount spent on advertising the Sony Bravia over the previous quarter is associated with an increase in sales of 3.0926 units, on average. Question 3 in determining the best companies to work for, a number of variables are considered, including size, average annual pay, and turnover rate, etc. Employee surveys are often conducted in order to assess aspects of the organization's culture, such as trust and openness to change. A sample of 33 companies was randomly selected and data collected on the average annual bonus and turnover rate (96). A questionnaire was also administered to the employees of each company to arrive at a trust index (measured on a scale of 0 100). The output is shown below. Dependent Variable is Turnover Rate 5 = 1.49746 RSq = 79.6% R-Sq(adj) = Predictor Coef SE Coef T P 78.3% Constant 12.1005 0.7826 15.46 0.000 A company having a Trust Index 0.07149 0.01966 -3.64 0.001 \"\"5\" '"dex \"we f 70 and an average Average Bonus 0.0007216 0.0001481 4.87 0.000 annual bonus of $6500 has a predicted turnover rate of: Question options: r\" 1.9%. 1'\" 2.4%. f\" 3.5%. i\" 4.2%. Question 4 Describe the phases of the data mining process in order. Question options: Data understanding, business understanding, modeling, data preparation, evaluation of models If" using test data set, and deployment. t\" Business understanding, data understanding, data preparation, modeling, evaluation of models using test data set, and deployment. Data understanding, business understanding, data preparation, modeling, evaluation of models (3* using test data set, and deployment. t\" Business understanding, data understanding, data preparation, evaluation of models using test data set, modeling, and deployment. Question 5 Data gathered from various telecommunication companies (e.g., cable, phone, internet service providers) and utility companies (electric, fuel, etc.) were merged into one data warehouse. Cell phone plan and number of residents: which are transactional and which are demographic? Question options: r" Type of cell phone plan-Transactional; Number of residents in householdDemographic. '5" Type of cell phone plan-Transactional; Number of residents in household-Transactional. 5' Type of cell phone plan-Demographic; Number of residents in household-Demographic. f" Type of cell phone plan-Demographic; Number of residents in household-Transactional. Question 6 Which is NOT a phase of the data mining process? Question options: F Business understanding '1" Data preparation (3' Modeling f\" None of the above Question 7 What affects flat panel LCD TV sales? Flat panel LCD TVs are sold through a variety of outlets. Sales figures (number of units) for the popular Sony Bravia were obtained for last quarter from a sample of 30 different stores. Also collected were data on the selling price and amount spent on advertising the Sony Bravia (as a percentage of total advertising expenditure in the previous quarter) at each store. Output is shown below. Analysis of Variance Source DF 55 MS Regression 2 16477.3 8238.7 Residual Error 27 3038.0 112.5 Total 29 19515.4 Based on the output shown below, how much ofthe variability In sales is explained by the estimated multiple regression model? Question options: t" 6.90% F 15.57% to\" 29% l" 84.43% Question 8 What affects at panel LCD TV sales? Flat panel LCD TVs are sold through a variety-of outlets. Sales figures (number of units) for the popular Sony Bravia were obtained for last quarter from a sample of 30 different stores. Also collected were data on the selling price and amount spent on advertising the Sony Bravia (as a percentage of total advertising expenditure in the previous quarter) at each store. The results are shown below. Dependent Variable is Turnover Rate 5 = 10.6075 R-Sq = 84.4% R-Sqiadj) = 83.3% Predictor Coef SE Coef T P The correct interpretation of the Constant 90-19 25-08 3'50 0-001 regression coefcient for Price is: Price -0.03055 0.01005 -3.04 0.005 Question options: Advertising 3.0925 0.3680 8.40 0.000 l\" increasing the price of the Sony Bravia by $100 will result in at least 3 fewer TVs sold. for a given amount spent on advertising, a 5100 increase in price of the Sony Bravia is associated with a decrease in sales of 3.055 units, on average. (3\" holding the amount spent on advertising constant, an increase of $100 in the price of the Sony Bravia will decrease sales by 3.055 units. holding the amount spent on advertising constant, an increase of $100 in the price of the Sony Bravla will decrease sales by .0396. 6" Question 9 In determining the best companies to work for, a number of variables are considered, including size, average annual pay, and turnover rate, etc. Employee surveys are often conducted in order to assess aspects of the organization's culture, such as trust and openness to change. A sample of 33 companies was randomly selected and data collected on the average annual bonus and turnover rate (96). A questionnaire was also administered to the employees of each company to arrive at a trust index (measured on a scale of 0 - 100). The output is shown below. Dependent Variable is Turnover Rate Predictor Coef SE Coef T P Constant 12.1005 0.7826 15.46 0.000 Trust Index 0.07149 0.01966 -3.64 0001 Average Bonus {3.0007216 0.0001481 -4.87 0.000 S = 149746 R'sq = 79.6% R-Sqiadj) = 78.3% At or = .01 we can conclude that: Question options: '1'" the multiple regression model is signicant overall. r" trust Index is a signicant independent variable in explaining turnover rate. r. Average Annual Bonus is a significant independent variable in explaining turnover rate. 5' All ofthe above Question 10 Data gathered from various telecommunication companies leg. cable, phone, internet service providers) and utility companies (electric, fuel, etc.) were merged into one data warehouse. Suppose data mining is employed to answer the following questions. Which is considered a regression problem? Question options: \"r\" Whether or not a customer would be interested in wireless internet capabilities i\" How much does a customer spend on all household communicationrelated expenditures? r. Whether or not a customer would be interested in flexible cable TV plans (subscribe to different channels on different days/times) 1"\" Both A and B Question 11 What affects flat panel LCD TV sales? Flat panel LCD TVs are sold through a variety of outlets. Sales gures (number of units) for the popular-Sony Bravia were obtained for last quarter from a sample of 30 different stores. Also collected were data on the selling price and amount spent on advertising the Sony Bravia (as a percentage of total advertising expenditure in the previous quarter) at each store. Output is shown below. Analysis of Variance Source DF 55 MS 03mm Variable is Turnover Ratgs4773 3233] S = 10.6075 R-Sq = 84.4% R-Sq (adj) = 83.3% ReediciairError Coef 27 5303836 T 112,? Which of the following statements is (mutant 90.19 29 ZMSA 3.60 0.001 TRUE? Price -0.03055 0.01005 -3.04 0.005 Question options: Advertising 3.0926 0.3680 8.40 0.000 t" The multiple regression model is signicant overall. f' Selling Price is a signicant independent variable in explaining Bravia sales. Amount Spent on Advertising is a signicant independent variable in
explaining Bravia sales. ' F 5' All of the above Question 12 What affects at panel LCD TV sales? Flat panel LCD TVs are sold through a variety of outlets. Sales figures (number of units) for the popular Sony Bravia were obtained for last quarter from a sample of 30 different stores. Also collected were data on the selling price and amount spent on advertising the Sony Bravia (as a percentage of total advertising expenditure in the previous quarter) at each store. Output Is shown below. Analysis of Variance Source DF SS MS Regression 2 16477.3 8238.7 Residual Error 27 3038.0 112.5 Total 29 19515.4 The calculated F statistic to determine the overall significance of the estimated multiple regression model is: Question options: F 3.60. 5' 10.61. 1" 73.23. V\" 112.5. Question 13 What affects flat panel LCD TV sales? Flat panel LCD TVs are sold through a variety of outlets. Sales gures (number of units) for the popular Sony Bravia were obtained for last quarter from a sample of 30 different stores. Also collected were data on the selling price and amount spent on advertising the Sony Bravia (as a percentage of total advertising expenditure in the previous quarter) at each store. The results are shown below. Dependent Variable is Turnover Rate S = 10.6075 RSq = 84.4% RSq(adj) = 83.3% Predictor Coef SE Coef T P The calculated t-statistic to Constant 90.19 25.08 3.60 0.001 determine if amount spent on advertising is a signicant Price 0.03055 0.01005 -3.04 0.005 , . _ Independent variable In explaining Advertising 3.0926 0.3680 3.40 0.000 Sony Bravia sales is: Question options: t'\" -3.o4. i\" 3.50. F 8.40. (k 10.61. Question 14 What affects flat panel LCD TV sales? Flat panel LCD TVs are sold through a variety of outlets. Sales figures (number of units) for the popular Sony Bravia were obtained for last quarter from a sample of 30 different stores. Also collected were data on the selling price and amount spent on advertising the Sony Bravia (as a percentage of total advertising expenditure in the previous quarter) at each store. The results are shown below. Dependent Variable is Turnover Rate 5 = 10.6075 R-Sq = 84.4% R-Sq(adj) = 83.3% Predictor Coef SE Coef T P Using the estimated multiple Constant 90.19 25.08 3.60 0.001 regresgion model: the number of units sold on average at a store that sells the Sony Bravia for $2199 and Advertising 3.0926 0.3680 8.40 0.000 Spends 10% of its advertising budget on the product is: Price 0.03055 0.01005 -3.04 0.005 Question options: 5' 53.94 units. F 66.54 units. F 90.34 units. 4'\" 120 units. Question 15 In determining the best companies to work for, a number of variables are considered, including size, average annual pay, and turnover rate, etc. Employee surveys are often conducted in order to assess aspects of the organization's culture, such as trust and openness to change. A sample of 33 companies was randomly selected and data collected on the average annual bonus and turnover rate (96). A questionnaire was also administered to the employees of each company to arrive at a trust index (measured on a scale of 0 100). The output is shown below. Dependent Variable is Turnover Rate 5 = 1.49746 R-Sq = 79.6% R-Sqladj) = Predictor Coef 5E Coef T P 73.3% Constant 12.1005 0.7826 15.46 0.000 What is the estimated multiple Trust Index 0.07 149 0.01956 -3.64 0.001 _ regressmn model? Average Bonus 0.0007216 0.0001481 -4.87 0.000 Question options: f\" Turnover Rate = 0.01966 Trust Index + 0.0001481 Average Bonus *5." Turnover Rate = 0.7826 + 0.01966 Trust Index + 0.0001481 Average Bonus 5" Turnover Rate = 12.1005 0.07149 Trust Index - 0.0007216 Average Bonus r\" Turnover Rate = 12.1005 + 0.07149 Trust Index + 0.0007216 Average Bonus Question 16 What affects at panel LCD TV sales? Flat panel LCD TVs are sold through a variety of outlets. Sales figures (n umber of units) for the popular Sony Bravia were obtained for last quarter from a sample of 30 different stores. Also collected were data on the selling price and amount spent on advertising the Sony Bravia (as a percentage of total advertising expenditure in the previous quarter) at each store. The results are shown below. Dependent Variable is Turnover Rate 5 = 10.6075 R-Sq = 84.4% R-Sqiadj) = 83.3% Predictor Coef SE Coef T P The correct null and alternative constant 90.19 25.08 3.60 0.001 hypotheses for testing the Price 0.03055 001005 3.04 0.005 regressnon coefCIent of price Is: . _ Question options: Advertismg 3.0926 0.3680 8.40 0.000 f\" H0:BP=0VS.HA:BP=0 r... H0: [3P 2 0 vs. HA : [3 P &|t;"} 0 {1 H0: BP 5 0 vs. HA : B P > > {"version":"1.1","math":""} 0 f\" Ho:ap=0vs.i-IA:BP0 Question 17 Data gathered from various telecommunication companies (e.g., cable, phone, internet service providers) and utility companies (electric, fuel, etc.) were merged into one data warehouse. Suppose data mining is employed on this data warehouse to answer the following questions. Indicate whether these involve a classification or regression problem. Is a customer interested in wireless internet capabilities? How much does a customer spend on all household communication-related expenditures? is a customer interested in exible cable TV plans (subscribe to different channels on different days/times)? Question options: f\" | is regression; ii is regression; III is classification i? I is classification; II is classification; III is regression r' l is classication; II is regression; III is regression i\" I is classication; II is regression; III is classication Question 18 allow(s) us to use algorithms that help us sort through multiple "what if" scenarios and approximate responses or anticipate outcomes. This further allows us to ascertain predictor variables. Question options: (7 Data mining 5' Regression analysis r" Decision trees 1" Analysis of variance Question 19 Data gathered from various telecommunication companies (e.g., cable, phone, internet service providers) and utility companies (electric, fuel, etc.) were merged into one data warehouse. Subscription, zip code, and monthly electricity usage: which are transactional and which are demographic? Question options: f\" Zip code-Demographic; Monthly electricity usageDemographic in Zip code-Transactional; Monthly electricity usage-Transactional W Zip code-Transactionai; Monthly electricity usage-Demographic 5" Zip code-Demographic; Monthly electricity usage-Transactional Question 20 Data gathered from various telecommunication companies (e.g. cable, phone, internet service providers) and utility companies (electric, fuel, etc.) were merged into one data warehouse. Below are some of the variables for which data were collected. which is/are transactional? Question options: i\" Type of cell phone plan if\" Zip code f' Household income 5' Both A and B Attempt Score: 40 / 100 - 4o % Overall Grade (highest attempt): 40 / 100 - 40 % Done