Exercise 12 19 Static (Using Analytic Solver) For Analytic Solver, partition the data sets into 50 training, 30 validation, and 20 test and use 12345 as the default random seed When searching for the optimal value of k , search within possible k values from 1 to 10 If the predictor variable values are in the character format, then treat the predictor variable as a categorical variable Otherwise, treat the predictor variable as a numerical variable Amanda Chen is the manager of a subscription firm that sells products on a scheduled time basis She would like to analyze the impact on subscription due to a recent marketing initiative where customers are offered a varying one time percentage discount (Discount) The response variable Subscribe equals 1 if the customer subscribes and 0 otherwise Other predictor variables used for the analysis are the customers' age and sex The accompanying file contains relevant data a Perform KNN analysis on the Subscription Data worksheet to determine the optimal k Enter the optimal k in the box below b What are the accuracy rates for k 3, k 4, and k 5 Note Report the accuracy rates in percentage Round your answers to 2 decimal places c 1 Report the accuracy, specificity, sensitivity, and precision rates for the validation data setusing the cutoff value of 0 65 Note Round your answers to 2 decimal places c 2 Which cutoff value does a better job identifying customers who end up subscribing to the product 0 35, 0 5, or 0 65 Note Round your answer to 2 decimal places d Score the records of the five potential customers in the Subscription Score worksheet What is the average probability of the five potential customers subscribing to the product Note Round your answer to 2 decimal places e Obtain the ROC curve What is the AUC value of the ROC curve Note Round your answer to 4 decimal places Subcription data worksheet Subscribe Discount Age Sex 1 5 48 Female 1 13 22 Female 1 15 51 Male 1 9 37 Female 0 7 72 Female 1 12 61 Male 0 7 37 Male 1 8 46 Male 1 3 71 Male 0 17 36 Female 0 2 27 Male 1 18 69 Male 1 12 39 Male 1 15 30 Female 1 5 69 Male 1 4 75 Female 1 6 37 Female 1 2 34 Female 1 10 61 Female 1 11 53 Female 0 5 20 Male 1 14 45 Female 1 5 31 Female 1 8 71 Male 1 14 53 Female 1 7 72 Male 1 12 73 Male 0 11 71 Female 0 10 34 Female 1 10 73 Female 1 5 61 Male 1 16 20 Female 0 9 27 Male 0 9 44 Male 1 18 38 Male 0 13 64 Female 1 18 68 Male 0 9 20 Female 0 8 63 Female 1 17 69 Female 1 9 23 Female 1 19 64 Male 1 14 68 Male 1 6 30 Female 0 6 17 Female 0 4 16 Male 0 16 47 Female 1 13 42 Female 1 3 58 Male 1 9 30 Female 0 15 20 Female 1 9 28 Female 1 18 76 Female 1 9 64 Female 0 3 54 Female 1 8 31 Female 1 20 40 Female 1 5 47 Female 1 6 70 Male 1 15 59 Male 1 19 26 Male 1 13 66 Male 1 18 28 Male 1 3 67 Male 1 14 52 Female 1 18 30 Male 1 19 27 Female 1 15 48 Female 0 10 57 Male 1 8 53 Female 1 19 42 Female 1 11 25 Female 1 11 62 Male 0 2 38 Male 1 17 36 Male 1 15 55 Female 1 18 60 Female 0 5 64 Female 1 15 61 Female 0 15 61 Female 1 8 28 Female 0 8 42 Male 1 15 74 Female 0 10 64 Male 0 13 35 Female 1 3 50 Female 1 6 59 Female 1 12 66 Female 0 16 40 Female 1 15 53 Male 0 18 64 Male 1 16 46 Female 0 5 53 Male 1 5 39 Female 1 2 24 Female 0 12 24 Male 1 3 74 Female 1 19 44 Male 1 14 44 Male 1 3 24 Female 0 5 71 Male 1 3 76 Male 0 8 24 Male 1 10 43 Female 0 3 75 Male 0 3 64 Male 1 12 39 Male 1 6 59 Male 0 9 24 Male 0 15 56 Male 1 19 39 Male 1 11 33 Male 0 13 23 Male 0 3 71 Male 0 15 61 Female 1 16 48 Male 0 3 63 Male 1 11 72 Male 1 9 37 Male 1 12 70 Male 1 12 24 Male 1 14 24 Female 0 3 52 Female 1 16 49 Female 1 3 56 Female 0 4 44 Female 0 5 53 Female 1 7 54 Female 0 2 23 Male 1 12 54 Male 0 6 69 Female 0 6 58 Male 1 3 76 Female 1 16 39 Female 1 3 31 Female 1 11 53 Male 0 18 22 Female 1 5 57 Male 1 12 51 Female 1 12 70 Male 0 5 25 Male 1 15 62 Male 0 5 28 Female 1 7 52 Female 1 3 36 Male 0 3 19 Male 0 4 76 Female 0 4 71 Female 0 4 16 Female 1 17 53 Female 1 15 70 Female 1 17 40 Female 1 18 29 Male 1 14 65 Female 0 5 16 Female 1 16 21 Female 0 17 59 Female 1 15 76 Female 0 20 58 Female 0 7 34 Male 0 17 48 Male 1 7 46 Male 1 19 39 Male 0 7 62 Female 0 3 29 Male 0 7 48 Female 1 8 55 Female 1 4 27 Male 1 18 48 Female 0 3 42 Male 1 7 31 Male 1 13 57 Female 1 18 25 Female 0 5 35 Female 1 9 18 Female 1 10 45 Male 1 9 41 Female 0 6 47 Male 1 16 48 Female 0 10 76 Male 1 7 45 Female 1 18 72 Female 1 17 29 Male 0 10 73 Male 1 12 39 Female 1 6 32 Male 1 8 43 Female 1 17 34 Male 0 6 50 Male 1 8 75 Female 0 3 44 Male 0 19 31 Male 0 7 33 Male 1 15 26 Female 1 11 27 Male 1 19 35 Male 0 3 63 Female 1 18 65 Female 1 18 60 Male 1 11 40 Female 0 5 69 Male 0 10 33 Male 0 4 46 Female 0 2 43 Female 1 13 68 Female 1 4 53 Male 1 10 58 Male 1 17 71 Female 0 3 47 Female 1 13 36 Female 1 15 43 Male 1 10 28 Female 0 5 54 Female 1 5 61 Female 0 3 60 Female 1 6 70 Female 1 9 49 Female 1 13 69 Male 1 11 27 Male 1 19 35 Female 1 6 39 Male 1 6 48 Female 1 5 74 Male 1 17 65 Female 0 18 26 Male 0 5 19 Male 1 17 63 Female 0 3 62 Male 0 14 64 Male 0 13 24 Male 1 18 39 Female 1 13 28 Male 1 18 67 Female 0 15 35 Female 1 20 27 Male 0 12 51 Male 1 19 41 Female 0 14 18 Female 0 6 19 Female 0 6 21 Male 0 5 44 Female 1 16 65 Female 0 5 23 Male 1 20 44 Female 0 4 61 Male 1 12 49 Male 0 2 38 Male 0 13 34 Male 1 12 62 Female 1 3 70 Female 0 8 27 Male 1 18 30 Male 1 7 63 Male 1 18 63 Male 1 13 36 Female 1 13 47 Male 0 17 48 Male 0 13 71 Male 0 3 70 Male 0 6 17 Male 1 11 31 Male 1 19 76 Female 0 4 18 Male 1 20 30 Female 1 9 35 Male 1 7 41 Female 1 16 71 Male 1 17 39 Male 1 14 37 Female 0 4 19 Male 1 14 73 Female 1 15 38 Female 1 8 60 Male 1 11 56 Male 0 16 26 Male 1 13 24 Male 1 11 75 Male 0 15 36 Female 1 19 46 Female 1 18 70 Male 0 3 28 Male 0 8 38 Female 1 6 29 Female 0 15 20 Female 1 6 57 Female 1 16 17 Male 1 9 58 Female 1 7 23 Female 1 17 41 Female 0 4 66 Female 1 14 50 Male 1 8 40 Female 0 4 17 Male 1 20 44 Female 1 15 54 Male 1 20 67 Male 0 7 33 Male 1 6 36 Male 0 3 21 Male 1 10 23 Female Subscription score worksheet Discount Age Sex 9 37 Female 5 20 Male 9 44 Male 3 58 Male 11 25 Female

Question: Exercise 12-19 Static (Using Analytic Solver) For Analytic Solver, partition the data sets into 50% training, 30% validation, and 20% test and use 12345 as

Exercise 12-19 Static (Using Analytic Solver)

For Analytic Solver, partition the data sets into 50% training, 30% validation, and 20% test and use 12345 as the default random seed. When searching for the optimal value of k, search within possible k values from 1 to 10. If the predictor variable values are in the character format, then treat the predictor variable as a categorical variable. Otherwise, treat the predictor variable as a numerical variable.

Amanda Chen is the manager of a subscription firm that sells products on a scheduled time basis. She would like to analyze the impact on subscription due to a recent marketing initiative where customers are offered a varying one-time percentage discount (Discount). The response variable Subscribe equals 1 if the customer subscribes and 0 otherwise. Other predictor variables used for the analysis are the customers' age and sex. The accompanying file contains relevant data.

a. Perform KNN analysis on the Subscription_Data worksheet to determine the optimal k. Enter the optimal k in the box below:

b. What are the accuracy rates for k = 3, k = 4, and k = 5?

Note: Report the accuracy rates in percentage. Round your answers to 2 decimal places.

c-1. Report the accuracy, specificity, sensitivity, and precision rates for the validation data setusing the cutoff value of 0.65.

Note: Round your answers to 2 decimal places.

c-2. Which cutoff value does a better job identifying customers who end up subscribing to the product: 0.35, 0.5, or 0.65?

Note: Round your answer to 2 decimal places.

d.Score the records of the five potential customers in the Subscription_Score worksheet. What is the average probability of the five potential customers subscribing to the product?

Note: Round your answer to 2 decimal places.

e. Obtain the ROC curve. What is the AUC value of the ROC curve?

Note: Round your answer to 4 decimal places.

Subcription_data_worksheet

Subscribe	Discount	Age	Sex
1	5	48	Female
1	13	22	Female
1	15	51	Male
1	9	37	Female
0	7	72	Female
1	12	61	Male
0	7	37	Male
1	8	46	Male
1	3	71	Male
0	17	36	Female
0	2	27	Male
1	18	69	Male
1	12	39	Male
1	15	30	Female
1	5	69	Male
1	4	75	Female
1	6	37	Female
1	2	34	Female
1	10	61	Female
1	11	53	Female
0	5	20	Male
1	14	45	Female
1	5	31	Female
1	8	71	Male
1	14	53	Female
1	7	72	Male
1	12	73	Male
0	11	71	Female
0	10	34	Female
1	10	73	Female
1	5	61	Male
1	16	20	Female
0	9	27	Male
0	9	44	Male
1	18	38	Male
0	13	64	Female
1	18	68	Male
0	9	20	Female
0	8	63	Female
1	17	69	Female
1	9	23	Female
1	19	64	Male
1	14	68	Male
1	6	30	Female
0	6	17	Female
0	4	16	Male
0	16	47	Female
1	13	42	Female
1	3	58	Male
1	9	30	Female
0	15	20	Female
1	9	28	Female
1	18	76	Female
1	9	64	Female
0	3	54	Female
1	8	31	Female
1	20	40	Female
1	5	47	Female
1	6	70	Male
1	15	59	Male
1	19	26	Male
1	13	66	Male
1	18	28	Male
1	3	67	Male
1	14	52	Female
1	18	30	Male
1	19	27	Female
1	15	48	Female
0	10	57	Male
1	8	53	Female
1	19	42	Female
1	11	25	Female
1	11	62	Male
0	2	38	Male
1	17	36	Male
1	15	55	Female
1	18	60	Female
0	5	64	Female
1	15	61	Female
0	15	61	Female
1	8	28	Female
0	8	42	Male
1	15	74	Female
0	10	64	Male
0	13	35	Female
1	3	50	Female
1	6	59	Female
1	12	66	Female
0	16	40	Female
1	15	53	Male
0	18	64	Male
1	16	46	Female
0	5	53	Male
1	5	39	Female
1	2	24	Female
0	12	24	Male
1	3	74	Female
1	19	44	Male
1	14	44	Male
1	3	24	Female
0	5	71	Male
1	3	76	Male
0	8	24	Male
1	10	43	Female
0	3	75	Male
0	3	64	Male
1	12	39	Male
1	6	59	Male
0	9	24	Male
0	15	56	Male
1	19	39	Male
1	11	33	Male
0	13	23	Male
0	3	71	Male
0	15	61	Female
1	16	48	Male
0	3	63	Male
1	11	72	Male
1	9	37	Male
1	12	70	Male
1	12	24	Male
1	14	24	Female
0	3	52	Female
1	16	49	Female
1	3	56	Female
0	4	44	Female
0	5	53	Female
1	7	54	Female
0	2	23	Male
1	12	54	Male
0	6	69	Female
0	6	58	Male
1	3	76	Female
1	16	39	Female
1	3	31	Female
1	11	53	Male
0	18	22	Female
1	5	57	Male
1	12	51	Female
1	12	70	Male
0	5	25	Male
1	15	62	Male
0	5	28	Female
1	7	52	Female
1	3	36	Male
0	3	19	Male
0	4	76	Female
0	4	71	Female
0	4	16	Female
1	17	53	Female
1	15	70	Female
1	17	40	Female
1	18	29	Male
1	14	65	Female
0	5	16	Female
1	16	21	Female
0	17	59	Female
1	15	76	Female
0	20	58	Female
0	7	34	Male
0	17	48	Male
1	7	46	Male
1	19	39	Male
0	7	62	Female
0	3	29	Male
0	7	48	Female
1	8	55	Female
1	4	27	Male
1	18	48	Female
0	3	42	Male
1	7	31	Male
1	13	57	Female
1	18	25	Female
0	5	35	Female
1	9	18	Female
1	10	45	Male
1	9	41	Female
0	6	47	Male
1	16	48	Female
0	10	76	Male
1	7	45	Female
1	18	72	Female
1	17	29	Male
0	10	73	Male
1	12	39	Female
1	6	32	Male
1	8	43	Female
1	17	34	Male
0	6	50	Male
1	8	75	Female
0	3	44	Male
0	19	31	Male
0	7	33	Male
1	15	26	Female
1	11	27	Male
1	19	35	Male
0	3	63	Female
1	18	65	Female
1	18	60	Male
1	11	40	Female
0	5	69	Male
0	10	33	Male
0	4	46	Female
0	2	43	Female
1	13	68	Female
1	4	53	Male
1	10	58	Male
1	17	71	Female
0	3	47	Female
1	13	36	Female
1	15	43	Male
1	10	28	Female
0	5	54	Female
1	5	61	Female
0	3	60	Female
1	6	70	Female
1	9	49	Female
1	13	69	Male
1	11	27	Male
1	19	35	Female
1	6	39	Male
1	6	48	Female
1	5	74	Male
1	17	65	Female
0	18	26	Male
0	5	19	Male
1	17	63	Female
0	3	62	Male
0	14	64	Male
0	13	24	Male
1	18	39	Female
1	13	28	Male
1	18	67	Female
0	15	35	Female
1	20	27	Male
0	12	51	Male
1	19	41	Female
0	14	18	Female
0	6	19	Female
0	6	21	Male
0	5	44	Female
1	16	65	Female
0	5	23	Male
1	20	44	Female
0	4	61	Male
1	12	49	Male
0	2	38	Male
0	13	34	Male
1	12	62	Female
1	3	70	Female
0	8	27	Male
1	18	30	Male
1	7	63	Male
1	18	63	Male
1	13	36	Female
1	13	47	Male
0	17	48	Male
0	13	71	Male
0	3	70	Male
0	6	17	Male
1	11	31	Male
1	19	76	Female
0	4	18	Male
1	20	30	Female
1	9	35	Male
1	7	41	Female
1	16	71	Male
1	17	39	Male
1	14	37	Female
0	4	19	Male
1	14	73	Female
1	15	38	Female
1	8	60	Male
1	11	56	Male
0	16	26	Male
1	13	24	Male
1	11	75	Male
0	15	36	Female
1	19	46	Female
1	18	70	Male
0	3	28	Male
0	8	38	Female
1	6	29	Female
0	15	20	Female
1	6	57	Female
1	16	17	Male
1	9	58	Female
1	7	23	Female
1	17	41	Female
0	4	66	Female
1	14	50	Male
1	8	40	Female
0	4	17	Male
1	20	44	Female
1	15	54	Male
1	20	67	Male
0	7	33	Male
1	6	36	Male
0	3	21	Male
1	10	23	Female

Subscription_score_worksheet

Discount	Age	Sex
9	37	Female
5	20	Male
9	44	Male
3	58	Male
11	25	Female

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To address this question accurately lets break down each part and proceed with a stepbystep approach as expected in a classroom setting while using co... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

How would I use a KNN Analysis to find the K VALUE of a data set that looks like this? 1 0.75 points Skipped eBook Exercise 9-5 Algo (Using Analytic Solver) For Analytic Solver, partition the data...

How would I go at finding the Binned of the data set 5 Exercise 9-24 Algo (Using Analytic Solver) For Analytic Solver, partition data sets into 60% training and 40% validation and use 12345 as the...

How would I go at finding the Binned_X1 for a data set 5 Exercise 9-24 Algo (Using Analytic Solver) For Analytic Solver, partition data sets into 60% training and 40% validation and use 12345 as the...

For Analytic Solver, partition the data sets into 50% training, 30% validation, and 20% test and use 12345 as the default random seed. When searching for the optimal value of k, search within...

For Analytic Solver, partition the data sets into 5 0 % training, 3 0 % validation, and 2 0 % test and use 1 2 3 4 5 as the default random seed. When searching for the optimal value of k , search...

Refer to Exercise 11 for a description of the data set. Partition the data into 60% training and 40% validation data. For Analytic Solver, use 12345 as the random seed and create 10 weak learners....

Can I have a step by step explanation to answer question using Analytic solver in excel: Personal Loan Acceptance. Universal Bank is a relatively young bank growing rapidly in terms of overall...

For Analytic Solver, partition data sets into 60% training and 40% validation and use 12345 as the default random seed. If the predictor variable values are in the character format, then treat the...

1. An experiment was run to compare the effects of auditory and visual cues on speed of response of a human subject. A personal computer was used to present a "stimulus" to a subject, and the...

The case below about Spar and Nisa companies, both firms in the same industry (Selling agricultural machinery) in UK and have provided you with the following financial information. Please read the...

Qumation 4 : Rrownety In: ( 1 4 ntex ( 6 ) ) 4 Enablect final twam Sened Hetp feve 8 titir Themer In comparison to industry averages, Okra Corporation has a low inventory turnover, a high curtent...

Create a C# application named SalesTransactionDemo that declares several SalesTransaction objects and displays their values and their sum. The SalesTransaction class contains the following fields:...