The major shopping areas in the community of Springdale include Springdale Mall, West Mall, and the downtown area on Main Street. A telephone survey has been conducted to identify strengths and weaknesses of these areas and to find out how they fit into the shopping activities of local residents. The 150 respondents were also asked to provide information about themselves and their shopping habits. The data are provided in the file SHOPPING. The variables in the survey can be found in the file CODING.

In this section, hypothesis testing will be used to examine the significance of some of the survey results. From a managerial perspective, the information gained from this database exercise would be useful in determining whether the mean attitude toward a given area differed significantly from the “neutral” level, in observing and comparing the mean attitude scores exhibited toward the three shopping areas, and in examining the strengths and weaknesses of a manager’s shopping area relative to the other two areas. If such a study were repeated from time to time, management could observe the extent to which the overall attitude toward their shopping area was becoming stronger or weaker in the eyes of the consumer, thus helping them select business strategies that could retain and take advantage of their area’s strengths and either correct or minimize the effect of its weaknesses.

1. Item C in the description of the data collection instrument lists variables 7, 8, and 9, which represent the respondent’s general attitude toward each of the three shopping areas. Each of these variables has numerically equal distances between the possible responses, and for purposes of analysis they may be considered to be of the interval scale of measurement.
   1. Calculate the mean attitude score toward the Springdale Mall shopping area and compute the sample standard deviation. Does this area seem to be well regarded by the respondents?
   2. In a two-tail test at the 0.10 level, compare the sample mean calculated in part (a) to the 3.0 “neutral” value. Use the null hypothesis H₀: u = 3.0 and the alternative hypothesis H₁: u ≠ 3.0.
   3. Generate the 90% confidence interval for the population mean and use this interval in verifying the conclusion obtained in part (b).
   4. What is the p-value associated with the hypothesis test?
   5. Repeat parts (a) through (d) for the Downtown shopping area.
   6. Repeat parts (a) through (d) for the West Mall shopping area.
2. If Springdale Mall offered exactly the same benefits as the other two shopping areas, we would expect exactly one-third of those who expressed an opinion to select it as the area best fitting the description for variable number 10 (“Easy to return/exchange goods”). In testing whether Springdale Mall differs significantly from this expected proportion, the null and alternative hypotheses will be H₀: π = 0.333 and H₁: π ≠ 0.333. Carry out the following analyses for Springdale Mall:
   1. Analyzing the data for variable 10, use the preceding null and alternative hypotheses in testing the null hypothesis at the 0.05 level.
   2. Determine the p-value for the test conducted in part (a).
   3. Repeat parts (a) and (b) for variables 11–17.
   4. Based on the preceding  analyses, identify the principal strengths and weaknesses exhibited by Springdale Mall.

Write a report that adheres to the Written Assignment Requirements under the heading “Expectations for CSU-Global Written Assignments” found in the CSU-Global Guide to Writing and APA Requirements. As with all written assignments at CSU-Global,  you should have in-text citations and a reference page too, all of which follow our APA requirements. 

Be sure that your report contains the following:

• A title page
• An introduction
• The body of the paper that answers the questions posed in the problems and includes calculations and graphs.
• A conclusion paragraph that addresses your findings and what you have determined from the data and your analysis. 

Be sure to submit your Excel file.

General Cereals is using a regression model to estimate the deamnd for Tweetie Sweeties, a whistle-shaped, sugar-coated cereal for children. The following multiplicative exponential demand function is being used:
QD (D is lower to the right)= 6,280P-2.15 A1.05 N3.70 (2.15, 1.05 3.70 are above the letters to the right)
where QD= quantity demanded in 10oz. boxes
P = price per box, in dollars
A = advertising expenditures on daytime television in dollars
N= proportion under 12 years old
1. Determine the point price elasticity of demand for Tweetie Sweeties
2. Determine the advertising elasticity of demand
3. What interpretation would you give to the exponent of N?
QUESTION #2
The demand for haddock has been estimated as:
log Q= a+b log P+c log I + d log Pm
where Q= quantity of haddock sold in New England
P= price per pound of haddock
I- a measure of personal income in the New England region
Pm= an index of the price of meat and poultry
1. If b = 2.174, c= 0.461 and d= 1.909:
Determine the price elasticity of demand
Determine the income elasticity of demand
Determine the cross price elasticity of demand
How would you characterize the demand for haddock?
Suppose disposable income is expected to increase by 5% next year. Assuming all other factors remain constant, forecast the percentage of change in the quantity of haddock demanded next year.
Question #3
An estimate of the demand function for household furniture produced the following results: F=0.0036Y (1.08 exponent)R(0.16 exponent) P -0.48 (exponent) r2 = 0.996
where F= furniture expenditures per household
Y= disposable personal income per household
R = value of private residential construction per household
P= ratio of the furniture price index to the consumer price index
a. Determine the point price and income elasticities for household furniture.
What interpretation would you give to the exponent for R? Why do you suppose R was included in the equation as a variable?
If you were a supplier to the furniture manufacturer, would you have preferred to see the analysis performed in physical sales units rather than dollars of revenue? How woul dthis change alter the interpretation of the price coeeficient presently estimated as .0.48?

ALL WORK MUST BE SHOWN YOU MUST SHOW HOW THE ANSWER WAS ACHEIVED IT MUST BE DONE BY 6PM EST 4/21/13