The Data is about a direct marketer of electronic equipment and wants to investigate the efficacy...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Data is about a direct marketer of electronic equipment and wants to investigate the efficacy in their company named HyTex. HyTex sent catalogues to the customers and the question might be that, if it is sending the catalogues to the right customers and if not, to whom should it send the catalogues to. The file "Catalogue Marketing.xlsx" contains customer demographic attributes including the Marital Status of the customer and the Region they live in. Y variable: Amount Spent = Total amount spent on purchases from HyTex ($). X variables: Male OwnHome Married Salary Children Catalogs = 1 if a person is a male and 0 if female. = = 1: if person owns home and 0 if renting. 1 if person is married and 0 otherwise. = Combined annual salary of person and spouse (if any). = Number of children living with person. = Number of catalogs sent to person this year. b) Use Excel to regress Amount Spent" on Male, OwnHome, Married, Salary, Children, Catalogues. Name the model Exhibit 2 and upload on Moodle. Exhibit 2: < upload the table on Moodle > (i) State and interpret the intercept. (ii) State and interpret the coefficient of "Salary". (iii) State and interpret the coefficient of "Catalogs". (iv) State and interpret the coefficient of "Married". (v) Use the model in Exhibit 2 above to predict the amount spent by the customer who is female, who is renting, not married, with a salary of $100,000 no children and supplied with 35 catalogues. Give your comment on reliability of the estimate. Show your working clearly. (vii) (vi) Perform a hypothesis test to determine whether having children influences the persons amount spent. Use a 1% level of significance and show all the steps. Use the p-value approach. To tell whether the above model is good or poor, we need to evaluate the model. An overall, amount spent mean is $12,16.77 Discuss two ways we can evaluate the model. A B C D E F G H | J 1 SUMMARY OUTPUT 12 3 Regression Statistics 4 Multiple R 5 R Square 0.84608597 0.71586147 6 Adjusted R Sq 0.71356772 7 Standard Erro 514.361424 8 Observations 9 10 ANOVA 11 12 Regression df 1000 SS MS F Significance F 1.265E-264 8 660555476 82569434.5 312.091924 991 262186565 264567.674 999 922742041 13 Residual 14 Total 15 16 Coefficients standard Error 17 Intercept 18 Person 19 Gender 20 OwnHome 21 Married 22 Close 23 Salary 24 Children 25 Catalogs 26 27 Upper 95% Lower 95.0% Upper 95.0% -150.59449 108.16131 Lower 95% -150.59449 108.16131 -0.1223493 0.09937469 -0.1223493 0.09937469 t Stat P-value -21.216589 65.9297244 -0.3218061 0.74766745 -0.0114873 0.0564942 -0.2033359 0.8389142 -43.331764 34.1811786 -1.2677083 0.20519991 -110.40756 23.7440367 -110.40756 23.7440367 38.4205291 36.9228167 1.04056333 0.29833205 -34.035354 110.876413 -34.035354 110.876413 -37.973818 44.486065 -0.8536115 0.39352655 -125.27152 49.323887 -125.27152 49.323887 -509.91376 36.2754903 -14.056702 4.6474E-41 -581.09936 -438.72817 -581.09936 -438.72817 0.02120951 0.00082212 25.7984192 1.093E-112 0.0195962 0.02282281 0.0195962 0.02282281 -205.28856 15.7923583 -12.999234 -174.29825-236.27886 -174.29825 42.7884613 2.54842353 16.7901688 7.1926E-56 37.7875352 47.7893874 37.7875352 47.7893874 8.6862E-36-236.27886 The Data is about a direct marketer of electronic equipment and wants to investigate the efficacy in their company named HyTex. HyTex sent catalogues to the customers and the question might be that, if it is sending the catalogues to the right customers and if not, to whom should it send the catalogues to. The file "Catalogue Marketing.xlsx" contains customer demographic attributes including the Marital Status of the customer and the Region they live in. Y variable: Amount Spent = Total amount spent on purchases from HyTex ($). X variables: Male OwnHome Married Salary Children Catalogs = 1 if a person is a male and 0 if female. = = 1: if person owns home and 0 if renting. 1 if person is married and 0 otherwise. = Combined annual salary of person and spouse (if any). = Number of children living with person. = Number of catalogs sent to person this year. b) Use Excel to regress Amount Spent" on Male, OwnHome, Married, Salary, Children, Catalogues. Name the model Exhibit 2 and upload on Moodle. Exhibit 2: < upload the table on Moodle > (i) State and interpret the intercept. (ii) State and interpret the coefficient of "Salary". (iii) State and interpret the coefficient of "Catalogs". (iv) State and interpret the coefficient of "Married". (v) Use the model in Exhibit 2 above to predict the amount spent by the customer who is female, who is renting, not married, with a salary of $100,000 no children and supplied with 35 catalogues. Give your comment on reliability of the estimate. Show your working clearly. (vii) (vi) Perform a hypothesis test to determine whether having children influences the persons amount spent. Use a 1% level of significance and show all the steps. Use the p-value approach. To tell whether the above model is good or poor, we need to evaluate the model. An overall, amount spent mean is $12,16.77 Discuss two ways we can evaluate the model. A B C D E F G H | J 1 SUMMARY OUTPUT 12 3 Regression Statistics 4 Multiple R 5 R Square 0.84608597 0.71586147 6 Adjusted R Sq 0.71356772 7 Standard Erro 514.361424 8 Observations 9 10 ANOVA 11 12 Regression df 1000 SS MS F Significance F 1.265E-264 8 660555476 82569434.5 312.091924 991 262186565 264567.674 999 922742041 13 Residual 14 Total 15 16 Coefficients standard Error 17 Intercept 18 Person 19 Gender 20 OwnHome 21 Married 22 Close 23 Salary 24 Children 25 Catalogs 26 27 Upper 95% Lower 95.0% Upper 95.0% -150.59449 108.16131 Lower 95% -150.59449 108.16131 -0.1223493 0.09937469 -0.1223493 0.09937469 t Stat P-value -21.216589 65.9297244 -0.3218061 0.74766745 -0.0114873 0.0564942 -0.2033359 0.8389142 -43.331764 34.1811786 -1.2677083 0.20519991 -110.40756 23.7440367 -110.40756 23.7440367 38.4205291 36.9228167 1.04056333 0.29833205 -34.035354 110.876413 -34.035354 110.876413 -37.973818 44.486065 -0.8536115 0.39352655 -125.27152 49.323887 -125.27152 49.323887 -509.91376 36.2754903 -14.056702 4.6474E-41 -581.09936 -438.72817 -581.09936 -438.72817 0.02120951 0.00082212 25.7984192 1.093E-112 0.0195962 0.02282281 0.0195962 0.02282281 -205.28856 15.7923583 -12.999234 -174.29825-236.27886 -174.29825 42.7884613 2.54842353 16.7901688 7.1926E-56 37.7875352 47.7893874 37.7875352 47.7893874 8.6862E-36-236.27886
Expert Answer:
Related Book For
Managerial Statistics
ISBN: 9780534389314
1st Edition
Authors: S. Christian Albright, Wayne L. Winston, Christopher Zappe
Posted Date:
Students also viewed these mathematics questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
During FY 2017, the voters of Surprise County approved construction of a $21 million police facility and an $11 million fire station to accommodate the county's population growth. The construction...
-
What are the major advantages of Fourier transform IR instruments over dispersive IR instruments?
-
Women of the working class, especially wage workers, should not have more than two children at most. The average working man can support no more and the average working woman can take care of no more...
-
If the force of gravity exerted by Earth on a fully suited astronaut at Earth's surface is \(1960 \mathrm{~N}\), what is the magnitude of the gravitational force exerted on her \((a)\) on Jupiter,...
-
The following information is available about items that differ between the governmental funds and the government-wide statements. Assume that there are no internal service funds. The schedule of...
-
Kubin Company's relevant range of production is 11,000 to 14,000 units. When it produces and sells 12,500 units, its average costs per unit are as follows: Average Cost per Unit Direct materials $...
-
Philippine Mares Corporation is a subsidiary of Singaporean Sophies Corporation. The functional currency of Philippines Mares is Peso (P) while the presentation currency of its parent. Singaporean...
-
What is common law illegality? What is the effect of illegality? What is subsequent illegality?
-
Locate three mission statements in the criminal justice system and describe how it fit into the organizational structure. Which one do you prefer? Why? How are the three different? Find a mission...
-
With the aid of practical examples, outline ANY Five (5) benefits brought by Information and Communication Technology (ICT) in education from when COVID-19 started to date.
-
Criminal Justice organizations need to make changes to meet the needs of a different type of employee entering 21st-century criminal justice organizations. As a professional law enforcement...
-
1.) What is the criminal justice organization/agency's purpose, goals, or mission? 2.) How does the criminal justice organization/agency support the general goals of criminal justice? 3.) Is this...
-
Prepare a simple research proposal related to investigate the impacts of motivation on employee performance and also describe that how performance is measured by Barclays Bank
-
Consider the activities undertaken by a medical clinic in your area. Required 1. Do you consider a job order cost accounting system appropriate for the clinic? 2. Identify as many factors as possible...
-
The accounting records of the Happy Tickers Sports and Social Club are in a mess. You manage to find the following information to help you prepare the accounts for the year to 31 December 2015. (1)...
-
The Milham Theatre Club has been in existence for a number of years. Members pay an annual subscription of 15 which entitles them to join trips to professional productions at a reduced rate. On 1...
-
Place a tick in the appropriate column for each of the following cost items: (a) Purchases of raw materials (b) Direct wages (c) General factory expenses (d) Depreciation of machinery (e) Commission...
Study smarter with the SolutionInn App