this is an excel problem can you help? The Station.xlsx file contains data for each family including
Fantastic news! We've Found the answer you've been seeking!
Question:
this is an excel problem can you help?
The Station.xlsx file contains data for each family including the family size (large or small), income (high or low), and whether the family bought a station wagon. Use this file to perform the following exercises:
a.Does it appear that family size or income is a more important determinant of station wagon purchases?
b.Compute the percentage of station wagon purchasers that are high or low income.
c.Compute the fraction of station wagon purchasers that come from each of the following categories: High Income Large Family, and Low
Station Wagon? | Family Size | Salary |
No | Small | High |
Yes | Large | High |
Yes | Large | High |
Yes | Large | High |
Yes | Large | High |
No | Small | High |
Yes | Large | High |
Yes | Large | High |
Yes | Large | Low |
Yes | Large | High |
Yes | Large | Low |
No | Small | Low |
No | Small | Low |
No | Small | High |
Yes | Large | High |
Yes | Large | High |
No | Small | High |
Yes | Large | High |
No | Small | High |
No | Large | Low |
Yes | Large | High |
No | Small | High |
No | Small | Low |
No | Small | Low |
Yes | Large | High |
No | Large | High |
No | Small | High |
No | Large | Low |
Yes | Large | High |
Yes | Large | High |
Yes | Large | High |
Yes | Large | Low |
No | Small | High |
No | Small | Low |
No | Small | High |
No | Small | Low |
No | Large | High |
No | Large | High |
No | Small | High |
No | Small | Low |
No | Small | High |
No | Small | High |
No | Small | High |
No | Large | High |
No | Small | High |
Yes | Small | High |
No | Small | High |
Yes | Large | High |
Yes | Large | Low |
No | Small | Low |
Yes | Large | High |
No | Small | High |
Yes | Large | High |
Yes | Large | High |
No | Large | High |
Yes | Large | High |
Yes | Large | High |
No | Large | High |
No | Large | High |
No | Small | High |
No | Small | High |
No | Large | High |
No | Small | Low |
No | Small | Low |
No | Small | High |
No | Small | High |
No | Small | High |
Yes | Large | High |
Yes | Large | Low |
No | Small | High |
Yes | Large | Low |
No | Small | High |
Yes | Large | Low |
Yes | Large | High |
No | Small | High |
No | Small | Low |
Yes | Large | High |
No | Large | Low |
No | Small | High |
No | Large | Low |
No | Small | High |
Yes | Large | High |
Yes | Large | High |
Yes | Large | High |
Yes | Small | High |
No | Large | High |
No | Small | High |
No | Large | High |
No | Small | High |
No | Small | High |
No | Small | High |
Yes | Large | High |
Yes | Large | High |
No | Small | High |
No | Large | Low |
Yes | Large | High |
Yes | Large | Low |
No | Small | High |
Yes | Large | High |
Yes | Large | High |
No | Small | Low |
No | Small | Low |
No | Small | High |
Yes | Large | High |
No | Small | Low |
Yes | Large | Low |
Yes | Large | High |
No | Small | Low |
No | Small | High |
Yes | Large | High |
Yes | Large | Low |
No | Small | High |
Yes | Large | High |
Yes | Large | High |
Yes | Large | Low |
No | Small | Low |
No | Large | High |
No | Large | High |
No | Small | High |
Yes | Large | Low |
No | Small | High |
Yes | Large | High |
No | Small | High |
No | Small | Low |
Yes | Large | Low |
No | Small | Low |
Yes | Large | High |
No | Small | Low |
No | Small | Low |
No | Small | Low |
No | Small | Low |
No | Small | Low |
Yes | Small | High |
No | Small | High |
Yes | Large | High |
Yes | Large | High |
Yes | Large | High |
Yes | Large | Low |
No | Small | High |
No | Small | High |
Yes | Large | High |
Yes | Large | High |
No | Small | Low |
No | Large | High |
No | Small | Low |
No | Small | Low |
No | Small | Low |
No | Small | Low |
Yes | Large | High |
Yes | Large | High |
Yes | Large | High |
No | Large | High |
Yes | Large | High |
No | Small | High |
No | Small | High |
Yes | Large | High |
Yes | Large | High |
Yes | Large | High |
No | Large | High |
No | Large | Low |
No | Small | High |
Yes | Small | Low |
Yes | Large | High |
Yes | Large | Low |
No | Small | High |
No | Large | Low |
Yes | Large | High |
Yes | Large | High |
Yes | Large | Low |
No | Small | High |
No | Large | High |
No | Small | High |
Yes | Large | High |
Yes | Large | High |
Yes | Small | High |
No | Small | High |
No | Large | High |
No | Small | Low |
No | Small | High |
No | Small | High |
Yes | Large | High |
Yes | Large | High |
Yes | Large | Low |
No | Small | Low |
No | Small | High |
Yes | Large | High |
Yes | Large | High |
No | Small | Low |
No | Small | High |
No | Small | High |
No | Small | High |
No | Large | High |
Yes | Small | High |
Yes | Large | Low |
No | Small | Low |
No | Small | High |
Yes | Large | Low |
Yes | Large | High |
Yes | Large | High |
No | Small | High |
Yes | Large | High |
No | Small | High |
Yes | Large | Low |
Yes | Large | Low |
No | Small | High |
No | Small | High |
No | Small | High |
Yes | Large | Low |
No | Small | Low |
No | Large | High |
Yes | Large | High |
No | Large | High |
Yes | Large | High |
No | Small | High |
No | Large | High |
Yes | Large | Low |
Yes | Large | High |
Yes | Large | High |
Yes | Large | Low |
No | Small | High |
No | Small | Low |
Yes | Large | High |
Yes | Large | High |
Yes | Large | High |
No | Large | High |
No | Small | Low |
No | Small | Low |
Yes | Large | High |
No | Small | Low |
No | Large | High |
Yes | Large | High |
Yes | Large | High |
Yes | Large | Low |
Yes | Large | High |
No | Large | Low |
No | Small | High |
No | Large | High |
No | Small | High |
Yes | Large | High |
Yes | Large | High |
Yes | Large | Low |
No | Small | High |
Yes | Large | Low |
Yes | Large | High |
No | Small | High |
Yes | Large | Low |
No | Small | High |
No | Small | High |
No | Small | High |
No | Small | High |
Yes | Large | High |
Yes | Large | High |
No | Small | High |
Yes | Large | High |
No | Small | High |
Yes | Large | High |
No | Large | Low |
Yes | Large | Low |
No | Small | High |
No | Small | High |
No | Small | High |
No | Small | Low |
Yes | Large | Low |
No | Small | High |
No | Large | Low |
No | Small | High |
No | Small | High |
No | Small | Low |
No | Small | High |
Yes | Large | High |
Yes | Large | Low |
Yes | Large | High |
No | Small | High |
No | Small | Low |
Yes | Large | High |
No | Small | High |
No | Small | Low |
Yes | Large | High |
No | Large | High |
No | Small | High |
No | Large | Low |
No | Small | High |
Yes | Large | High |
Yes | Large | High |
Yes | Large | High |
Yes | Large | High |
Yes | Large | High |
No | Small | High |
No | Small | High |
No | Small | Low |
No | Small | High |
No | Large | High |
No | Small | High |
No | Small | High |
Yes | Large | High |
Yes | Large | Low |
No | Small | High |
No | Large | High |
Yes | Large | Low |
Yes | Large | Low |
No | Small | High |
No | Large | Low |
No | Small | High |
No | Small | High |
Yes | Large | Low |
No | Small | High |
Yes | Large | High |
Yes | Small | High |
Yes | Large | Low |
No | Small | Low |
No | Small | High |
Yes | Large | High |
Yes | Small | High |
No | Small | High |
No | Large | High |
Yes | Large | Low |
No | Small | High |
Yes | Large | High |
Yes | Large | High |
Yes | Large | High |
Yes | Large | High |
Yes | Large | Low |
No | Small | High |
No | Large | High |
No | Small | High |
No | Small | High |
No | Large | High |
Yes | Large | High |
No | Small | High |
No | Small | High |
No | Small | High |
Yes | Small | High |
No | Large | High |
No | Large | High |
No | Large | Low |
No | Small | High |
Yes | Large | High |
No | Small | High |
No | Large | High |
No | Large | Low |
Yes | Large | High |
No | Large | High |
Yes | Small | Low |
Related Book For
Managerial Statistics
ISBN: 9780534389314
1st Edition
Authors: S. Christian Albright, Wayne L. Winston, Christopher Zappe
Posted Date: