Question: The Department of Defense has hired Blue Consultants to determine if there are differences in preference for health care plans among current, prospective, and retired members of the military. Prospective recruits, current members, and retirees were randomly selected, contacted, and asked to indicate their preference for the Basic, Gold, or Prime health care plan. The results are presented in Table F4.

1. Using mathematical symbols, specify the linear model that is most appropriate for testing the relationship between military status and health care plan preference.
2. Construct a pivot table that summarizes the data in Table F4.
3. Analyze the data. Specify the analytical technique you used and managerially interpret the results. Include Excel output to support your analysis.
4. Graphically illustrate the relationship between military status and health care plan preference.

Price: $2.99

Solution: The downloadable solution consists of 3 pages
Deliverable: Word Document