I’m trying to study for my Statistics course and I need some help to understand this question.
Please show work in excel.
1. Suppose Foot Locker strongly encourages its
employees to make formal suggestions to improve the store, the product, and the
working environment. Suppose a quality auditor keeps records of the suggestions,
the persons who submitted them, and the geographic region from which they come.
A possible breakdown of the number of suggestions over a 3-year period by
employee sex and geographic location follows. Is there any relationship between
the sex of the employee and the geo-graphic location in terms of number of
suggestions? If they are related, what does this relationship mean to the
company? What business implications might there be for such an analysis?
*Supplement attached for this question with chart
Results: chi-square = 28.7
degrees of freedom = 5
probability = 0.000
a) is there a relationship between geographic location and sex in terms of
numbers of suggestions?, and b) if they are related, what does this
relationship mean to the company?
2. Executives of a video rental chain want to predict the success of a
potential new store. The company’s researcher begins by gathering information
on number of rentals and average family income from several of the chain’s
Develop a regression model to predict the number of rentals per day by the
average family income. Comment on the output.
**Supplement attached for this question with chart