Question 2: Tayko Software is a software catalog firm that sells games and educational software. It...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Question 2: Tayko Software is a software catalog firm that sells games and educational software. It started out as a software manufacturer and then added third-party titles to its offerings. It recently revised its collection of items in a new catalog, which it mailed out to its customers. This mailing yielded 2000 purchases. Based on these data, Tayko wants to devise a model for predicting the spending amount that a purchasing customer will yield. The file Tayko.csv contains information on 2000 purchases. Table below describes the variables to be used in the problem (the Excel file contains additional variables). Description of Variables for Tayko Software Example FREQ LAST_UPDATE WEB GENDER ADDRESS_RES ADDRESS_US Number of transactions in the preceding year Number of days since last update to customer record Whether customer purchased by Web order at least once Male or female Whether it is a residential address Whether it is a US address SPENDING (response) Amount spent by customer in test mailing (in dollars) a. Prepare the data to contain only the above listed variables. b. Explore the spending amount by creating a pivot table for the categorical variables and computing the average and standard deviation of spending in each category. c. Explore the relationship between spending and each of the two continuous predictors by creating two scatterplots (Spending vs. Freq, and Spending vs. last_update_days_ago. Does there seem to be a linear relationship? d. To fit a predictive model for Spending: i. ii. iii. Partition the 2000 records into training (75%) and validation (25%) sets. Fit at least 2 prediction models (e.g. linear regression, stepwise regression, neural networks, etc.) to the training data. Evaluate the predictive accuracy of the model by examining its performance on the validation set. iv. Discuss the predictive performance of both models. Question 2: Tayko Software is a software catalog firm that sells games and educational software. It started out as a software manufacturer and then added third-party titles to its offerings. It recently revised its collection of items in a new catalog, which it mailed out to its customers. This mailing yielded 2000 purchases. Based on these data, Tayko wants to devise a model for predicting the spending amount that a purchasing customer will yield. The file Tayko.csv contains information on 2000 purchases. Table below describes the variables to be used in the problem (the Excel file contains additional variables). Description of Variables for Tayko Software Example FREQ LAST_UPDATE WEB GENDER ADDRESS_RES ADDRESS_US Number of transactions in the preceding year Number of days since last update to customer record Whether customer purchased by Web order at least once Male or female Whether it is a residential address Whether it is a US address SPENDING (response) Amount spent by customer in test mailing (in dollars) a. Prepare the data to contain only the above listed variables. b. Explore the spending amount by creating a pivot table for the categorical variables and computing the average and standard deviation of spending in each category. c. Explore the relationship between spending and each of the two continuous predictors by creating two scatterplots (Spending vs. Freq, and Spending vs. last_update_days_ago. Does there seem to be a linear relationship? d. To fit a predictive model for Spending: i. ii. iii. Partition the 2000 records into training (75%) and validation (25%) sets. Fit at least 2 prediction models (e.g. linear regression, stepwise regression, neural networks, etc.) to the training data. Evaluate the predictive accuracy of the model by examining its performance on the validation set. iv. Discuss the predictive performance of both models.
Expert Answer:
Posted Date:
Students also viewed these mathematics questions
-
Solar Energy Corp. has $4 million in earnings with four million shares outstanding. Investment bankers think the stock can justify a P/E ratio of 21. Assume the underwriting spread is 5 percent. What...
-
Choose the correct answer for each of the following questions. 1. On November 15, 20X3, Chow Inc., a U.S. company, ordered merchandise FOB shipping point from a German company for ¬200,000. The...
-
Will the preferences shown in the following table lead to a voting paradox? Briefly explain. Kathleen David 2nd 1st 3rd Lena Policy Cancer research Mass transit Border security 1st 3rd 2nd 1st 2nd 3rd
-
In each of four independent cases, the amount of differential revenue or differential cost is as follows (parentheses indicate decreases): For each case, determine the missing amount that would be...
-
Using the information in Problem 3, calculate the sample size needed if the standard time estimate is to be within 5 percent of the true mean 99 percent of the time. Calculate the percentage increase...
-
Question: In Java, How To Iterate Through And Print All Combinations Of A Given String. Example: String "@#$%&Amp;" Should Print @, #,
-
Solve It Using Conjugate Beam Method EI = constant 2 kN/m A 2m 1.5m C calculate a.) A b.) B c.) DE d.) OF Aut B for 1.5m- Im E 0.7 kNm e.) SA f.) SF g.) Sc h.) Smax the following: 4m 5 kN/m F
-
(10 points) Let f (x) 1. f'(1)= -2/5 2. f'(6)= = 2 Evaluate each of the following:
-
Gopwani Inc., manufactures and distributes clay pots. Over the years due to neglect of this product, sales have decreased to approximately 20,000 units per year from a previous high of 100,000 units....
-
Hook Industries capital structure consists of solely debt and equity. It can issue debt at ra -11% and its common stock currently pays a dividend of $2 per share. The stock's current price is $24.75,...
-
a) Anis have three children, Atikah, Ahmad and Adam. Atikah is 25 years old while her brother, Ahmad, younger 7 years than her. If Adam is younger than Ahmad, determine Adam's age. (2 Marks) b) Misha...
-
Please define the attached terms in a MS Word file. Use only these acceptable sources: 1). Black's Law Dictionary - You must cite the edition used, i.e. 14th edition: 2). Text Book. You must cite the...
-
What is a marginal cost? a. how limited a good is b. what groups give up to gain something c. how the total of production influences price d. how price influences demand Pick an answer and elaborate...
-
Show, if u(x, y) and v(x, y) are harmonic functions, that u + v must be a harmonic function but that uv need not be a harmonic function. Is e"e" a harmonic function?
Study smarter with the SolutionInn App