# Hello there, I need some help for this very easy and fun BUS 311 (Data Analysis and Decision Modeling) activity please

Probability Activity Please submit Excel file. Show any pivot tables. On answers to the questions, please create the formulas in Excel. In other words, I would like to see how you got the answers. I don’t want to see just the answers. 🙂
1. In a study designed to gauge married women’s participation in the workplace today, the data provided in the file Working Women.xlsx (I AM ATTACHING THIS FILE BELOW) were obtained from a sample of 750 randomly selected married women (fictitious). Consider a woman selected at random from this sample in answering the following questions.
What is the probability that this woman has a job outside the home?
What is the probability that this woman has at least one child?
What is the probability that this woman has a full-time job and no more than one child?
What is the probability that this woman has a part-time job or at least one child, but not both?
2. A local beer producer sells two types of beer, a regular brand and a light brand with 30% fewer calories. The company’s marketing department wants to verify that its traditional approach of appealing to local white-collar workers with light beer commercials and appealing to local blue-collar workers with regular beer commercials is indeed a good strategy. A randomly selected group of 400 local workers are questioned about their beer-drinking preferences, and the data in the file Cheers and Beers.xlsx (fictitious) are obtained.
If a blue-collar worker is chosen at random from this group, what is the probability that he/she prefers light beer (to regular beer or no beer at all)?
If a white-collar worker is chosen at random from this group, what is the probability that he/she prefers light beer (to regular beer or no beer at all)?
If you restrict your attention to workers who like to drink beer, what is the probability that a randomly selected blue-collar worker prefers to drink light beer?
If you restrict your attention to workers who like to drink beer, what is the probability that a randomly selected white-collar worker prefers to drink light beer?
Does the company’s marketing strategy appear to be appropriate? Explain why or why not.