The file P02 03.xlsx contains data from a survey of 399 people regarding a government...

90.2K

Verified Solution

Question

Accounting

The file P02 03.xlsx contains data from a survey of 399 people regarding a government environmental policy. a. Create a crosstabs and an associated column chart for Gender versus Opinion. Express the counts as percentages so that for either gender, the percentages add to 100%. Discuss your findings. Specifically, do the two genders tend to differ in their opinions about the environmental policy? Repeat part a with Age versus Opinion. c. Recode Salary to be categorical with categories "Less than $40K," "Between $40K and $70K," "Between $70K and $100K," and "Greater than $100K (where you can treat the breakpoints however you like). Then repeat part a with this new Salary variable versus Opinion. b.
image
2. The file P02_03.xlsx contains data from a survey of 399 people regarding a government environmental policy. a. Create a crosstabs and an associated column chart for Gender versus Opinion. Express the counts as percentages so that for either gender, the percentages add to 100%. Discuss your findings. Specifically, do the two genders tend to differ in their opinions about the environmental policy? b. Repeat part a with Age versus Opinion. c. Recode Salary to be categorical with categories "Less than \$40K," "Between \$40K and \$70K," "Between \$70K and \$100K" and "Greater than $100K " (where you can treat the breakpoints however you like). Then repeat part a with this new Salary variable versus Opinion

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students