Statistics Homework

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 present outlets.

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