Upper management has asked you to construct a pivot table and pivot chart showing a. Annual Charges in rows and group annual charges (each group width must be $12,000) b. Household size in columns and group the household size by 3. Interpret the pivot table/chart. 6. You are also asked to create two more pivot table/chart (you can pick any variable, any group size, any variable in rows and columns etc.). The rows/columns in your pivot table must be different than Part 5. Explain why you picked these pivot table? What does pivot chart tell us about the dataset? Please remember data visualization is very useful if they provide us a story about the dataset, if your graph and pivot table is not clear and not explaining data well, it will not be useful Account Number x1 Annual Income ($1000) x2 Household Size x3 Years of Post-High School Education x4 Hours Per Week Watching Television x5 Age x6 Gender (1:Female, 0:Male) x7 Exceded Credit Limit in Past 12 Months? (No:0, Yes:1) y Annual Charges ($) 23313578 21.8 4.0 5.0 29.0 47 1 0 10023.52 14168784 65.5 7.0 3.0 46.0 60 1 0 11248.76 498076 54.2 3.0 2.0 18.0 47 0 0 6115.00 12286258 73.7 6.0 0.0 44.0 41 0 0 9785.55

Q: Type your food Budge Sheet

A:

Q: Describe the process of using the Balance Scale model as an illustration to solve the problem.…

A:

Q: A furniture store expects to sell 120 coffee tables during the next year. It costs $1.50 to store…

A:

Q: The manager of a university bookstore is trying to determine whether or not to advance purchase…

A: Uncertainties and PW of options are given as: Results of past predictions are given as:

Q: Identify the independent and dependent variables in the following scenarios. Explain each choice.

A:

Q: 7.) The ticket prices to a museum are $5.50 for adults and $3.00 for students. How much will it cost…

A:

Q: Post 2 replies to classmates. Be constructive and professional. These responses should be at least…

A: We have to define above term i.e nominal ordinal, ratio and interval data.

Q: 3. Emily and Andy each go to a hardware store to buy wire. The table shows the relationship between…

A: Emily needs wire= 24 ft

Q: A supplement was given to patients to lower their blood pressure. The blood pressure before and…

A: We know that the blood pressure readings are made up with two values; Systolic Blood pressure…

Q: WinCo Foods ()Walmart (µ2) WinCo Foods, a large discount grocery retailer in the Western United…

A: First, we need to check σ12 =σ22 or not  ================================ F-Test Two-Sample for…

Q: 5. Label each relationsh.p below as proportional or additive. Johnathan went to play video games at…

A:

Q: The table shows the cost of 3 different loaves of bread and the number of slices for each loaf. What…

A: The given table shows the cost of 3 different loaves of bread and the number of slices for each…

Q: What variables are the following, explain why. Ordinal, nominal, ratio or interval 1.Birth order…

A: Introduction: The nominal and ordinal scales are used to measure qualitative data, while the…

Q: 2. Write a rule of the amount that the eggs were sold when each tray contains 30 eggs and costs and…

A: Consider that the cost of one tray of 30 eggs is 210 pesos and discount on each transaction is 20…

Q: 6. Consider a monocentric city in which all houses contain 1,300 square feet of floor space, and…

A: please find the attached image

Q: $12,000 $10,000 $8,000 $6,000 $4,000 $2,000 $0 $1,000 $6,000 Profit $1,500 $7,500 $2,100 Revenue…

A: Remark   Ration of revenue yo  profit =revenueprofit

Q: During one month, the rate for renting a particular car model was $68.18 per day plus 25¢ per mile.…

A: Given:  Let x denote the number of miles driven. Let y denote the total cost in dollars.

Q: 3. Explain the difference between patch A and patch B in the figure below. What does this difference…

A: This question is about the differences between Patch A and Patch B as seen from the overview below.…

Q: Write a 1-page memo to the CEO. Include each chart (3) and a paragraph per chart. Each paragraph…

A: [Your Name] [Your Position] [Date]Subject: Visualizations and Insights from Recent Data AnalysisDear…

Q: Which situation best represents a proportional relationship? O Sandra sold 2 bracelets for $3 and 3…

A:

Q: 3. ComCo Cell Phone Company offers another cell phone plan called Plan B. With this plan, the…

A:

Q: 12. Vintage Wines has fixed costs of $20,000 per year. Its warehouse sells wine with variable costs…

A: The formula for calculating the break-even point is:Break-even point = Total fixed costs / (Unit…

Q: Here's the revenue and expenses for the month. Calculate whether Mia had a profit or loss. JANUARY…

A:

Q: novement of the progress Dar may be uneven because questions can be worth more or less (lICiuding…

A: 1st he drives 750 miles. Second he drives 2488 miles. 3rd he drives 155 miles. 4th he drives 1015…

Q: A smartphone device has a certain cost.  A person gets this smartpone and sign up for a monthly…

A: The independent variable is The cost of the smartphone.

Q: 26. Cigarette Tax Rates The table shows the tax, in dollars, on a pack of cigarettes in each of the…

A: Arrange data in ascending order 0.17, 0.30, 0.36, 0.37, 0.425, 0.44, 0.45, 0.55, 0.57, 0.57, 0.60,…

Q: A marketing manager for a large cafeteria chain wished to investigate sales of coffee (i.e., sales…

A: Let Y=SalesX=number of dispensers…

Market Research Methodology

Market research refers to employing strategies, collecting data, and studying the target audience of a product by an organization. Businesses analyze customer data to figure out consumer trends, improve product design, improve user experience, develop customer-centric marketing campaigns, generate high-quality leads, and boost conversion rates. Phone surveys, test marketing strategies, and focus groups can be used for marketing research.