Buad 310 Case Analysis Instruction

BUAD 310 Spring 2013 Case Due by 4PM on Friday, whitethorn 3rd (in BRI 400C) In this case you will apply statistical techniques knowing in the Regression disjoint of BUAD 310. Please read the following book of instructions cargonfully before you start This assignment uses data from the file MagAds13S. XLS, which you flush toilet download from Blackboard. After you download the file go to Data excite data from file in StatCrunch to open it (you dont ingest to change any of the options when loading this data. ) The entire report should be typed and distinctly presented without typos and grammatical errors.Copy and paste the relevant (explained further in more detail) retroflection output into your document. Do not attach any graphs. You are back up to scat in gatherings (maximum size is 5). Any group submits only virtuoso report, in which the first page should have each(prenominal) the names and USC ID of the group members. A hard copy of the report carrys to be subm itted (an electronic copy is non acceptable). Before May 3rd, you bay window also pop off in the report during class. When I am not in my smudge (BRI 400C), please drop the report in the office through the cleft among the door and floor. Very important present the problems in hardly the said(prenominal) order as they are listed. A note to mac user you might fate to hold shift when selecting variable stars for the X-variables with multiple elongated retroflection in StatCrunch. Magazine Advertising What factors influence the price of advertisements in magazines? Suppose you are part of a team of consultants hired by a retail clothing company wishing to place advertisements in at least one magazine. They are curious about what types of be they can expect for magazines with incompatible readership bases so they most effectively implement their advertising budget.Your team has collected cost data on 44 consumer magazines. In addition, your team has measured some other ch aracteristics of the magazines and their audiences that may be useful in downstairsstanding the advertisement costs better. The variables are as follows, pagecost Cost of a four-color, one-page ad (in dollars) circ Circulation (projected, in thousands) percmale Percent male among the predicted readership medianincome median(a) household income of readership (in dollars) Some natural logarithms of the variables are also provided for your convenience.Your goal is to die the data with StatCrunch employ Multiple Linear Regression methods and choose the better model to explain the differences in advertising costs between the different titles, and then to predict what the retail clothing company should expect to right for advertising in the different magazines. Answer the following headlands (with reasonable detail, not just yes or no, use one or 2 denounces per question). 1. Visually examine the scatter flecks of the response variable, pagecost, versus severally of the explan atory variables (circ, percmale, medianincome).In StatCrunch you can go to Graphics( chase away Plot to do each plot. Describe the form and the heed of each relationship. Do not attach any graphs. 2. Perform a Regression analysis to predict pagecost using all three explanatory variables Stat ( Regression ( Multiple Linear, then fill in the puritanical response and Predictor variables, then click Next twice and under part with options select Residuals, Predicted determine and 95% interval for either the call up or an individual (you will have to decide which one you need for part d ). For he CI (or PI) to be produced you need to enter the set from part d in the row underneath the data table, in appropriate columns. Note that the value for circ has to be entered in the same units as all the values in the circ column. To produce a remnant plot do a Scatter plot as in question 1, selecting Residuals as the Y variable and Predicted values as the X variable. intromit the regress ion output, but not the plot. a. Use the R-squared and the F-test to comment on the advantage of the regression model you fitted (use the importee level of 5% for the test). b.Evaluate the regression assumptions by assessing the residual plot. c. Examine each of the explanatory variables individually to determine which are alter significantly to the model. (Use the significance level of 5 %. Do NOT actually eliminate any variables from the regression at this stage. ) d. Using the same model with all the variables, provide an appropriate 95%-level interval to the retail clothing company for the amount that they would pay for a full-page ad in a magazine with a projected audience of 2,000,000 readers, 55 percent of which are male, with a median income of $30,000.Explain in one sentence and in simple-minded name what this interval means. 3. Rerun the regression in part 2 with circ replaced by LN_circ (the natural logarithm of the variable circ), memory all the other variables the same. involve the relevant regression output (only the coefficient and analysis of variance tables). Stat ( Regression ( Multiple Linear, then fill in the proper solvent and Predictor variables, then click Next twice and under keep up options select Residuals and Predicted values. Produce a residual plot the same counseling as in question 2. a.How does this model compare to the previous model using R-squared? Explain what this difference in the R-squared values means in simple terms. b. Evaluate the regression assumptions by assessing the residual plot. c. Examine each of the independent variables individually to determine which are contributing significantly to the lateest model. (Use the significance level of 5 %. Do NOT actually eliminate any variables from the regression at this stage. ) 4. Rerun the regression in part 3 with LN_pagecost (the natural logarithm of pagecost) as the response (i. . the explanatory variables are LN_circ, percmale and medianincome). Include the regression output. Stat ( Regression ( Multiple Linear, then fill in the proper Response and Predictor variables, then click Next twice and under Save options select Residuals, Predicted values and 95% interval for either the mean or an individual (you will have to decide which one you need for part d ). For the CI (or PI) to be produced you need to enter the values from part d in the row underneath the data table, in appropriate columns.Note that the value for LN_circ has to be entered in the same units as all the values in the LN_circ column. Also note that the interval will be produced for the LN_pagecost variable. To produce a residual plot do a Scatter plot as in question 1, selecting Residuals as the Y variable and Predicted values as the X variable. a. Evaluate the regression assumptions by assessing the residual plot. b. Examine each of the explanatory variables individually to determine which are contributing significantly to the new model. Use a significance level of 5%. . Remove the variables you find insignificant and re-run the model. Include the regression output for the new model. d. Using the new model, provide an appropriate 95% -level interval to the retail clothing company for the amount they would pay for a full-page ad in a magazine with the values given in 2. d (projected audience of 2,000,000 readers, 55 percent of which are male, with a median income of $30,000) using the newest model. Explain in one sentence and in simple terms what this interval means. EXECUTIVE SUMMARY (roughly about ? to 1 page)You are given the task of summarizing your findings for the board of directors of the retail clothing company. Since they are not very(prenominal) well-versed in regression techniques, you will need to explain things in easy-to-understand, simple and practical terms. Make sure to answer the following questions within the analysis 1. Describe each of the models you considered in parts 2-4 and how these models estimate the relationship betwe en the cost of one-page ad and each of the explanatory variables (for each of the models you will need about one sentence per explanatory variable). . Specify which model you would remember to best forecast the cost of one-page advertisements. Explain why this model should work well and why you picked this particular model from the ones you tried (go over the positives you jibe for this model and the negatives for the other models). Reminder include only the relevant regression output in your final document. Do not attach or include any graphs.