Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can someone please answer these question with explanation and values too please Task 3: Modeling (3 points) 6. Create 3 models consisting of each of
Can someone please answer these question with explanation and values too please
Task 3: Modeling (3 points) 6. Create 3 models consisting of each of the Variable Selection Methods a. Forward, Backward, Stepwise Task 4: Evaluation (10 points) 7. What is the adjusted R2 value of each model? 8. What is the overall p-value of the model? Is this acceptable? 9. For each of the models above, provide the variables that made it into the model a. Show evidence of this with corresponding p-values. Are they all significant? 10. Are there any assumptions that need to be evaluated? a. Show evidence of this and explain your reasoning. Task 5: Deployment (20 points) 11. You are part of the business intelligence team in your company and have been requested to prepare a 1-page fact sheet to management regarding predicting values for our customers with respect to their potential for getting them the best possible investments. B C D E F DE 28.88 12.39 0.67 2-Star 1.41 3-Star IE 14.37 30.53 10.73 3.34 0.49 4-Star DE 24.94 10.88 0.99 3-Star DE 46.39 11.32 1.03 2-Star IE 25.52 24.95 1.23 3-Star DE 16.92 15.67 1.18 3-Star DE 50.67 16.77 1.31 5-Star DE 36.58 18.14 1.08 4-Star DE 35.73 15.85 1.20 4-Star DE 15.29 17.25 1.02 3-Star DE 24.32 17.77 1.32 4-Star DE 13.47 17.23 0.53 3-Star FI 12.51 4.31 0.44 4-Star DE 31.86 18.23 1.00 5-Star DE 73.11 17.99 0.89 5-Star FI 12.58 4.41 0.45 5-Star IE 48.39 23.46 0.90 4-Star DE 45.60 13.50 0.89 3-Star FI 8.60 2.76 0.45 3-Star DE 39.85 14.40 0.56 4-Star FI 10.95 4.63 0.62 3-Star 2 Amer Cent Inc & Growth Inv 3 American Century Intl. Disc 4 American Century Tax-Free Bond FI 5 American Century Ultra 6 Ariel 7 Artisan Intl Val 8 Artisan Small Cap 9 Baron Asset 10 Brandywine 11 Brown Cap Small 12 Buffalo Mid Cap 13 Delafield 14 DFA U.S. Micro Cap 15 Dodge & Cox Income 16 Fairholme 17 Fidelity Contrafund 18 Fidelity Municipal Income 19 Fidelity Overseas 20 Fidelity Sel Electronics 21 Fidelity Sh-Term Bond 22 Fideliy 23 FPA New Income 24 Gabelli Asset AAA 25 Greenspring 26 Janus 27 Janus Worldwide 28 Kalmar Gr Val Sm Cp 29 Managers Freemont Bond 30 Marsico 21st Century 31 Mathews Pacific Tiger 32 Meridan Value 33 Oakmark 34 PIMCO Emerg Mkts Bd D 35 RS Value A 36 T. Rowe Price Latin Am. 37 T. Rowe Price Mid Val 38 Templeton Growth A 39 Thornburg Value A 40 USAA Income 41 Vanguard Equity-Inc 42 Vanguard Global Equity 43 Vanguard GNMA 44 Vanguard Sht-Tm TE 45 Vanguard Sm Cp Idx 46 Wasatch Sm Cp Growth DE 49.81 16.70 1.36 4-Star DE 23.59 12.46 1.07 3-Star DE 32.26 12.81 0.90 3-Star IE 54.83 12.31 0.86 2-Star DE 15.30 15.31 1.32 3-Star FI 10.56 5.14 0.60 5-Star DE 17.44 15.16 1.31 5-Star IE 27.86 32.70 1.16 3-Star DE 31.92 15.33 1.08 4-Star DE 40.37 9.51 1.05 2-Star 1.25 3-Star FI 10.68 13.57 DE 26.27 23.68 1.36 4-Star IE 53.89 51.10 1.24 4-Star DE 22.46 16.91 0.80 4-Star IE 24.07 15.91 1.01 3-Star DE 37.53 15.46 1.27 4-Star FI 12.10 4.31 0.62 3-Star 0.29 4-Star DE 24.42 13.41 IE 23.71 21.77 0.64 5-Star FI 10.37 4.25 0.21 5-Star FI 15.68 2.37 0.16 3-Star DE 32.58 17.01 0.23 3-Star DE 35.41 13.98 1.19 4-Star Task 3: Modeling (3 points) 6. Create 3 models consisting of each of the Variable Selection Methods a. Forward, Backward, Stepwise Task 4: Evaluation (10 points) 7. What is the adjusted R2 value of each model? 8. What is the overall p-value of the model? Is this acceptable? 9. For each of the models above, provide the variables that made it into the model a. Show evidence of this with corresponding p-values. Are they all significant? 10. Are there any assumptions that need to be evaluated? a. Show evidence of this and explain your reasoning. Task 5: Deployment (20 points) 11. You are part of the business intelligence team in your company and have been requested to prepare a 1-page fact sheet to management regarding predicting values for our customers with respect to their potential for getting them the best possible investments. B C D E F DE 28.88 12.39 0.67 2-Star 1.41 3-Star IE 14.37 30.53 10.73 3.34 0.49 4-Star DE 24.94 10.88 0.99 3-Star DE 46.39 11.32 1.03 2-Star IE 25.52 24.95 1.23 3-Star DE 16.92 15.67 1.18 3-Star DE 50.67 16.77 1.31 5-Star DE 36.58 18.14 1.08 4-Star DE 35.73 15.85 1.20 4-Star DE 15.29 17.25 1.02 3-Star DE 24.32 17.77 1.32 4-Star DE 13.47 17.23 0.53 3-Star FI 12.51 4.31 0.44 4-Star DE 31.86 18.23 1.00 5-Star DE 73.11 17.99 0.89 5-Star FI 12.58 4.41 0.45 5-Star IE 48.39 23.46 0.90 4-Star DE 45.60 13.50 0.89 3-Star FI 8.60 2.76 0.45 3-Star DE 39.85 14.40 0.56 4-Star FI 10.95 4.63 0.62 3-Star 2 Amer Cent Inc & Growth Inv 3 American Century Intl. Disc 4 American Century Tax-Free Bond FI 5 American Century Ultra 6 Ariel 7 Artisan Intl Val 8 Artisan Small Cap 9 Baron Asset 10 Brandywine 11 Brown Cap Small 12 Buffalo Mid Cap 13 Delafield 14 DFA U.S. Micro Cap 15 Dodge & Cox Income 16 Fairholme 17 Fidelity Contrafund 18 Fidelity Municipal Income 19 Fidelity Overseas 20 Fidelity Sel Electronics 21 Fidelity Sh-Term Bond 22 Fideliy 23 FPA New Income 24 Gabelli Asset AAA 25 Greenspring 26 Janus 27 Janus Worldwide 28 Kalmar Gr Val Sm Cp 29 Managers Freemont Bond 30 Marsico 21st Century 31 Mathews Pacific Tiger 32 Meridan Value 33 Oakmark 34 PIMCO Emerg Mkts Bd D 35 RS Value A 36 T. Rowe Price Latin Am. 37 T. Rowe Price Mid Val 38 Templeton Growth A 39 Thornburg Value A 40 USAA Income 41 Vanguard Equity-Inc 42 Vanguard Global Equity 43 Vanguard GNMA 44 Vanguard Sht-Tm TE 45 Vanguard Sm Cp Idx 46 Wasatch Sm Cp Growth DE 49.81 16.70 1.36 4-Star DE 23.59 12.46 1.07 3-Star DE 32.26 12.81 0.90 3-Star IE 54.83 12.31 0.86 2-Star DE 15.30 15.31 1.32 3-Star FI 10.56 5.14 0.60 5-Star DE 17.44 15.16 1.31 5-Star IE 27.86 32.70 1.16 3-Star DE 31.92 15.33 1.08 4-Star DE 40.37 9.51 1.05 2-Star 1.25 3-Star FI 10.68 13.57 DE 26.27 23.68 1.36 4-Star IE 53.89 51.10 1.24 4-Star DE 22.46 16.91 0.80 4-Star IE 24.07 15.91 1.01 3-Star DE 37.53 15.46 1.27 4-Star FI 12.10 4.31 0.62 3-Star 0.29 4-Star DE 24.42 13.41 IE 23.71 21.77 0.64 5-Star FI 10.37 4.25 0.21 5-Star FI 15.68 2.37 0.16 3-Star DE 32.58 17.01 0.23 3-Star DE 35.41 13.98 1.19 4-StarStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started