Question

Excel can be used to create a wide variety of charts to suit different purposes. All you need is the data that you want to transform into a chart! In this section, you are going to generate some data and then use that data to create your own charts.

You must create the following charts:

Line Graph
Pie Chart
Diagram
The data you generate for this is up to you, but you must create a table with at least 10 rows of realistic data. You will need to perform an online search to get more information about the type of data you want to generate.

As an example (but you will come up with your own idea), you could create some data for a movie enthusiast who attends as many sci-fi openings as they can. You could track the title of the movie, the month they went, how much the ticket cost, and how many times they went to see it. For this, you would search online to gather when hit sci-fi movies came out in the past year, how much tickets cost in your area, etc.

Or, you could create data for a runner training for a marathon and keep a log of dates, distances, mile pace, and calorie intake. For this, you would search online to find a training regimen that is realistic for a runner prepping for a marathon and use it to create your data.

After you have created a table, use it to build a line graph, a pie chart, and a diagram in a way that gives a good visualization of your data, something that you can use to interpret and come up with conclusions about that data.

Save your table as well as all of your charts. You will need them for the next step.
n this step, you are going to pretend you are in the sales and marketing department of a company, and your job is to pitch marketing ideas based on the data various teams have gathered in your charts. You will create a five- to seven-minute video presentation of yourself showing each of your three charts (you can display them on a screen or print them out as a poster presentation) and interpreting your data in a way that leads you to an idea for a new product or different service that could be marketed toward the person or business represented by your data.

Your data interpretation should include:

Analysis of the chart: What can your marketing team conclude about people or businesses who exhibit the trends your data is showing?
Pitch: What new product or service might these people or businesses be interested in?

Answer 1

All 3, Line graph, Pie chart, and Diagram are Below

Step-by-step explanation:

Here is the data I put together for this project :

First Name Last Name Number of Children

Richard Carroll 3

George Davis 2

Vanessa Montgomery 3

Camila Foster 4

Frederick Johnson 0

Rosie Ferguson 0

Patrick Holmes 5

Roman Dixon 0

Richard Jones 5

Spike Kelley 5

Please enjoy, and have a great day <3