Computers And Technology High School

Use Pivot Chart and Pivot tables to find information about these customers
Find the percentage of homeowners, broken down by age group, marital status, and gender (20 Points)
Find the percentage married, broken down by age group , homeowner status, and gender (20 Points)
Find the average salary broken down by age group , gender, marital status and homeowner status (20 points)
Find the percentages in the customer spending history broken down by number of children and whether they live close to the store (10 points)
What is the percentage receiving the various number of catalogs for each value of the customer spending history (10 Points)
Use this link of the excel https://1drv.ms/x/s!AvQITuN6GvNfiU6z89-i6sJlZ4QK?e=M7Ofnh

Answers

Answer 1

Pivot charts and pivot tables can be used to extract valuable information about customers from the provided Excel file.

By analyzing the data, we can determine the percentage of homeowners by age group, marital status, and gender; the percentage of married individuals by age group, homeowner status, and gender; the average salary by age group, gender, marital status, and homeowner status; the percentages in customer spending history by number of children and proximity to the store; and the percentage of customers receiving various numbers of catalogs based on their spending history.

Using the provided Excel file, you can create pivot tables and pivot charts to analyze the data and answer the given questions. Start by selecting the relevant columns for each analysis, such as age group, marital status, gender, homeowner status, salary, number of children, proximity to the store, and catalog quantity.

For each question, create a pivot table with the desired breakdowns. For example, to find the percentage of homeowners broken down by age group, marital status, and gender, set the age group, marital status, and gender as row labels, and add the homeowner status as a column label. Then, calculate the percentage of homeowners within each category.

Similarly, for the other questions, create pivot tables with the appropriate breakdowns and calculate the required percentages or average values based on the provided criteria.

To visualize the results, you can create pivot charts based on the pivot table data. Pivot charts provide a visual representation of the analyzed data, making it easier to interpret and present the findings.

By utilizing pivot tables and pivot charts in Excel, you can quickly derive the required information about customers, such as the percentages of homeowners, married individuals, average salary, spending history breakdowns, and catalog distribution based on the provided data.

Learn more about  Pivot charts   here:

https://brainly.com/question/32219507

#SPJ11

Related Questions

Other Questions
An How many milliliters ahould the client receive per dosel 9. Order prazosin (Minipreas) 10mgPO, daily. Available: prasosin 1-mg 2-mg and 5 -mg tablets Which tablet should be selected and bow much should be giveni 10. Order carbidopa-levodopa (Sinemet) 12.5-125 mg PO, b.L.d Available; Sinemet 25- to 100 -, 25-to 250-, 10- to 100 -mg, tablets Which tablet should be selected and how much should be given? Additional Dimensional Analysis: 11. Order omepnivole (Pritosec) 20 an P(O, daiiy: Available: Factors: 10mg=1 capsule (drug label) Conversion factor: none (both are in inilligrams) How many capsule (s) should the chient receivel 12. Order amoxicillin (Amoxil) 0.1.g PO, PBh Available Factors: 200mg=5ml (drug label) Conversion factor 1000mg=1 g How many milliliters should the dient receive per dose? What is the correct order of words to fill in the blanks in the following quote by Sun Tzu. "All men can see these whereby I conquer, but what none can see is the out of which victory is evolved". tactics, strategy strength, weaknesses strategy, tactics threats, opportunities The illustration below shows the grain flow of a geartooth. What was the main manufacturing process used to create thefeature?CastingPowder MetallurgyForgingExtruded 3- In an air conditioning system, the inside and outside condition are 25oC DBT, 50% RH and 40oC DBT, 27oC WBT respectively. The room sensible heat factor is 0.8. 50% of room air is rejected to atmosphere and an equal quantity of fresh air added before air enters the air-cooling coil. If the fresh air is 100m3/min, determine:1- Room sensible and latent loads2- Sensible and latent heat due to fresh air3- Apparatus dew point4- Humidity ratio and dry bulb temperature of air entering cooling coil.Assume by-pass factor as zero, density of air 1.2kg/m3 at pressure 1.01325bar Determine the weight in newton's of a woman whose weight in pounds is 130. Also, find her mass in slugs and in kilograms. Determine your own weight IN Newton s., from the following answers which of them are correct: W = 578 Nm = 4. 04 slugs and m = 58. 9 kg W = 578 Nm = 4. 04 slugs and m = 68.9 kg W= 578 N, m = 8. 04 slugs and m = 78. 9 kg W= 578 N, m = 8. 04 slugs and m = 48. 9 kg A Lactobacillus strain is growing in milk. At 5 hours the cell concentration is 5 x 10 CFU/ml whereas at 10 hours the cell concentration is 4 x 108 CFU/ml. Assuming that the cells are growing exponentially during this period, calculate the maximum specific growth rate (max) (30 marks) Fick's first law gives the expression of diffusion flux (l) for a steady concentration gradient (c/ x) as: J=-D c/ xComparing the diffusion problem with electrical transport analogue; explain why the heat treatment process in materials processing has to be at high temperatures. Find a homogeneous linear differential equation with constant coefficients whose general solution is given.1. y = c1 cos 6x + c2 sin 6x2. y = c1ex cos x + c2ex sin x3. y = c1 + c2x + c3e7x The end of the cylinder with outer diameter = 100 mm and inner diameter =30 mm and length = 150 mm will be machined using a CNC lathe machine with rotational speed =336 rotations per minute, feed rate = 0.25 mm/ rotation, and cutting depth = 2.0 mm. Machine mechanical efficiency =0.85 and specific energy for Aluminum = 0.7 Nm/m. Determine: i. Cutting time to complete face cutting operation (sec). ii. Material Removal Rate (mm/s). iii. Gross power used in the cutting process (Watts). Navigation systems: Please address each point below individually and support your conclusion with example(s) from the website. 3.1. Identify the embedded navigation system (global, local, & contextual) available in the site and show examples for each. Justify your answer. 3.2. Does the site include supplemental navigation? Identify it and show an example. 3.3. Does the site include any form of advanced navigation? Identify it and show an example. 1 In this assignment, you will identify and set yourown goals.1. Complete the following in a 1-2 pagepaper:OIdentify at least one short-term,one mid-term, and one-long termgoal.Identify at least one specificobjective for each of your goals.Discuss the potential challengesthat you might face in meetingeach of your goals.Describe the strategies you willuse to track your progress inmeeting your goals.Explain how you will rewardyourself when you meet a goal. Now we're going to design another "equalizer". Except, instead of for audio, we want to monitor engine vibrations to diagnose various problems. Suppose we have a four-cylinder engine with a single camshaft. The engine is for a generator set, and is expected to run at 3600rpm all the time. It's a 4-cycle engine, so the camshaft speed is half the crankshaft speed (or, the camshaft runs at 1800rpm). We want to measure the following things... Vibrations caused by crankshaft imbalance. Vibrations caused by camshaft imbalance. Vibrations caused by the exhaust wave. The exhaust wave pulses whenever an exhaust valve opens. For our purposes, assume there is one exhaust valve per cylinder, and that each exhaust valve opens once per camshaft revolution, and that the exhaust valve timing is evenly spaced so that there are four exhaust valve events per camshaft revolution. 1. Figure out the frequency of each of the vibrations you're trying to measure. 2. Set the cutoff frequencies for each of your bandpass filters. Psychographics: Why is Psychographics more valuable to marketersthan demographics in developing marketing strategies? TRUE-FALSE 36. All producers are plants. 37. Tropical rain forests contain more species because the environment is continually changing, which offers a wider variety of microhabitats for organisms to exploit 38. One main difference between the temperate deciduous grassland and the temperate deciduous forest is in the amount of precipitation they recieve. Which of the following codes for a protein? Multiple Choice a. mRNA b. tRNA c.16S RNAd. 70S RNAe. rRNA pls help if you can asap!! victor chooses a code that consists of 4 4 digits for his locker. the digits 0 0 through 9 9 can be used only once in his code. what is the probability that victor selects a code that has four even digits? What comprises a household's purchasing power? O occupation and income O social class and education O age and gender O income and accumulated wealth O income and education (10 marks) Suppose (x.f) = A(x - x)e-it/h, Find V(x) such that the equation is satisfied. the practice of sports illustrated distributing different versions of a given issue in which editorial content and ads vary according to some specific demographic or regional grouping is referred to as