Question
Using the data shown in the sheet Cars [which your previously worked with on your fists exam.] Create pivot tables using the variables vehicle Type and weight to answer the following questions. What is the marginal probability that a consumer owns a car? What is the joint probability that a consumer owns an that weighs 4501-6000lbs? What is the conditional probability that if a consumer owns a vehicle that weighs 3000-4500lbs, if is also a truck? What is the conditional probability that if a consumer owns a car, it weighs less than 3300 lbs?
Explanation / Answer
Please provide the data to make Pivot. Steps of making it would be:
--> Take vehicle type in rows of pivot table
---> Take weights in the column section of pivot table
--> Again take vehicle type in the values section of pivot table
The resultant Pivot would be the one you are looking for.