TESM E104 Registration Data Analysis Assignment You are the Event Manager for the Midwest Association of Home Remodelers and just returned from your associations annual convention Your boss would like you to analyze the registration data from the event for the post event report Use the Excel file in the weeks Module titled Registration Data for Assignment to complete your analysis Your boss would like your analysis to be provided to him in a Word file To complete this analysis you will need to do the following (see your Excel training for help) Note All numbers should be whole numbers, meaning that decimals should NOT be included Create a Chart Showing the Percentage of Attendees from Each State Add up the number of attendees from each state and input the number in the graph tab Total the number of attendees Calculate the percentage of total each state represents Using the states and percentages, create a pie chart Change the chart title to Attendees by State, use Calibri font size 14 Add data labels to your chart, so that the percentage each piece of the pie represents shows up in the pie Ensure the chart has a legend and it is on the right side Ensure the data labels and legend are Calibri font size 12 Copy the chart area and paste it in the Word doc as an editable chart it cannot be an image of the chart WARNING Total should not be included and no numbers should be in your chart, only percentages Create a Chart Showing the Percentage of Attendees in Each Age Range Add up the number of attendees in each age range and input the number in the graph tab Total the number of attendees Calculate the percentage of total each age range represents Using the age ranges and percentages, create a bar chart Change the chart title to Attendees by Age Range, use Calibri font size 14 Either the X or Y axis should include ALL of the age ranges, on this axis add an axis title of Age Ranges, use Calibri font size 12 for both title and labels Either the X or Y axis should include percentages, the labels on this axis should start at 0 and end at 30 with an added axis title of Percentage, use Calibri font size 12 for both title and labels Add data labels to your chart, so that the percentage each bar represents shows up outside the end of the bar, use Calibri font size 12 Copy the chart area and paste it in the Word doc as an editable chart it cannot be an image of the chart WARNING Total should not be included and no numbers should be in your chart, only percentages Create a Chart Showing the Percentage of Attendees that are Members versus Non Members Add up the number of attendees that are members and the number that are non members and input the number in the graph tab Total the number of attendees Calculate the percentage of the total for member and non member Using the types of member non member and percentages, create a pie chart Change the chart title to Members vs Non Members, use Calibri font size 14 Add data labels to your chart, so that the percentage each piece of the pie represents shows up in the pie Ensure the chart has a legend and it is on the right side Ensure the data labels and legend are Calibri font size 12 Copy the chart area and paste it in the Word doc as an editable chart it cannot be an image of the chart WARNING Total should not be included and no numbers should be in your chart, only percentages Create a Chart Showing What Percentage of Attendees Heard About the Event in Different Ways Add up the number of attendees for each way they would have heard about the event and input the number in the graph tab Total the number of attendees Calculate the percentage of total each way represents Using the ways they could have heard about the event and percentages, create a bar chart Change the chart title to How Attendees Heard About the Event, use Calibri font size 14 Either the X or Y axis should include ALL of the ways they could have heard about the event, on this axis add an axis title of Methods, use Calibri font size 12 for both title and labels Either the X or Y axis should include percentages, the labels on this axis should start at 0 and end at 50 with an added axis title of Percentage, use Calibri font size 12 for both title and labels Add data labels to your chart, so that the percentage each bar represents shows up outside the end of the bar, use Calibri font size 12 Copy the chart area and paste it in the Word doc as an editable chart it cannot be an image of the chart WARNING Total should not be included and no numbers should be in your chart, only percentages Create a Chart Showing What Attendees Say is Their Primary Reason for Coming to the Event Add up the number of attendees for each reason they come to the event and input the number in the graph tab Total the number of attendees Calculate the percentage of total each reason represents Using different reasons and percentages, create a bar chart Change the chart title to Why Attendees Come to the Event, use Calibri font size 14 Either the X or Y axis should include ALL of the possible primary reasons, on this axis add an axis title of Primary Reason, use Calibri font size 12 for both title and labels Either the X or Y axis should include percentages, the labels on this axis should start at 0 and end at 50 with an added axis title of Percentage, use Calibri font size 12 for both title and labels Add data labels to your chart, so that the percentage each bar represents shows up outside the end of the bar, use Calibri font size 12 Copy the chart area and paste it in the Word doc as an editable chart it cannot be an image of the chart WARNING Total should not be included and no numbers should be in your chart, only percentages Create a Chart Showing the Percentage of Attendees by Highest Education Level Add up the number of attendees for in each education level and input the number in the graph tab Total the number of attendees Calculate the percentage of total each education level represents Using the education levels and percentages, create a bar chart Change the chart title to Highest Education Level of Attendees, use Calibri font size 14 Either the X or Y axis should include ALL of the possible highest education levels, on this axis add an axis title of Highest Education, use Calibri font size 12 for both title and labels Either the X or Y axis should include percentages, the labels on this axis should start at 0 and end at 50 with an added axis title of Percentage, use Calibri font size 12 for both title and labels Add data labels to your chart, so that the percentage each bar represents shows up outside the end of the bar, use Calibri font size 12 Copy the chart area and paste it in the Word doc as an editable chart it cannot be an image of the chart WARNING Total should not be included and no numbers should be in your chart, only percentages After all, charts have been created and pasted into a Word doc, center them and make sure that the layout looks professional Add your name, class, assignment, and date in the top left corner Submit this as a Word file only

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 20, 2024

TESM E104 Registration Data Analysis Assignment You are the Event Manager for the Midwest Association of Home Remodelers and just returned from your associations annual

TESM E104

Registration Data Analysis Assignment

You are the Event Manager for the Midwest Association of Home Remodelers and just returned from your associations annual convention. Your boss would like you to analyze the registration data from the event for the post event report. Use the Excel file in the weeks Module titled Registration Data for Assignment to complete your analysis. Your boss would like your analysis to be provided to him in a Word file.

To complete this analysis you will need to do the following (see your Excel training for help):

Note: All numbers should be whole numbers, meaning that decimals should NOT be included.

Create a Chart Showing the Percentage of Attendees from Each State

Add up the number of attendees from each state and input the number in the graph tab
Total the number of attendees
Calculate the percentage of total each state represents
Using the states and percentages, create a pie chart
Change the chart title to Attendees by State, use Calibri font size 14
Add data labels to your chart, so that the percentage each piece of the pie represents shows up in the pie
Ensure the chart has a legend and it is on the right side
Ensure the data labels and legend are Calibri font size 12
Copy the chart area and paste it in the Word doc as an editable chart it cannot be an image of the chart
WARNING: Total should not be included and no numbers should be in your chart, only percentages

Create a Chart Showing the Percentage of Attendees in Each Age Range

Add up the number of attendees in each age range and input the number in the graph tab
Total the number of attendees
Calculate the percentage of total each age range represents
Using the age ranges and percentages, create a bar chart
Change the chart title to Attendees by Age Range, use Calibri font size 14
Either the X or Y axis should include ALL of the age ranges, on this axis add an axis title of Age Ranges, use Calibri font size 12 for both title and labels
Either the X or Y axis should include percentages, the labels on this axis should start at 0% and end at 30% with an added axis title of Percentage, use Calibri font size 12 for both title and labels
Add data labels to your chart, so that the percentage each bar represents shows up outside the end of the bar, use Calibri font size 12
Copy the chart area and paste it in the Word doc as an editable chart it cannot be an image of the chart
WARNING: Total should not be included and no numbers should be in your chart, only percentages

Create a Chart Showing the Percentage of Attendees that are Members versus Non-Members

Add up the number of attendees that are members and the number that are non-members and input the number in the graph tab
Total the number of attendees
Calculate the percentage of the total for member and non-member
Using the types of member/non-member and percentages, create a pie chart
Change the chart title to Members vs. Non-Members, use Calibri font size 14
Add data labels to your chart, so that the percentage each piece of the pie represents shows up in the pie
Ensure the chart has a legend and it is on the right side
Ensure the data labels and legend are Calibri font size 12
Copy the chart area and paste it in the Word doc as an editable chart it cannot be an image of the chart
WARNING: Total should not be included and no numbers should be in your chart, only percentages

Create a Chart Showing What Percentage of Attendees Heard About the Event in Different Ways

Add up the number of attendees for each way they would have heard about the event and input the number in the graph tab
Total the number of attendees
Calculate the percentage of total each way represents
Using the ways they could have heard about the event and percentages, create a bar chart
Change the chart title to How Attendees Heard About the Event, use Calibri font size 14
Either the X or Y axis should include ALL of the ways they could have heard about the event, on this axis add an axis title of Methods, use Calibri font size 12 for both title and labels
Either the X or Y axis should include percentages, the labels on this axis should start at 0% and end at 50% with an added axis title of Percentage, use Calibri font size 12 for both title and labels
Add data labels to your chart, so that the percentage each bar represents shows up outside the end of the bar, use Calibri font size 12
Copy the chart area and paste it in the Word doc as an editable chart it cannot be an image of the chart
WARNING: Total should not be included and no numbers should be in your chart, only percentages

Create a Chart Showing What Attendees Say is Their Primary Reason for Coming to the Event

Add up the number of attendees for each reason they come to the event and input the number in the graph tab
Total the number of attendees
Calculate the percentage of total each reason represents
Using different reasons and percentages, create a bar chart
Change the chart title to Why Attendees Come to the Event, use Calibri font size 14
Either the X or Y axis should include ALL of the possible primary reasons, on this axis add an axis title of Primary Reason, use Calibri font size 12 for both title and labels
Either the X or Y axis should include percentages, the labels on this axis should start at 0% and end at 50% with an added axis title of Percentage, use Calibri font size 12 for both title and labels
Add data labels to your chart, so that the percentage each bar represents shows up outside the end of the bar, use Calibri font size 12
Copy the chart area and paste it in the Word doc as an editable chart it cannot be an image of the chart
WARNING: Total should not be included and no numbers should be in your chart, only percentages

Create a Chart Showing the Percentage of Attendees by Highest Education Level

Add up the number of attendees for in each education level and input the number in the graph tab
Total the number of attendees
Calculate the percentage of total each education level represents
Using the education levels and percentages, create a bar chart
Change the chart title to Highest Education Level of Attendees, use Calibri font size 14
Either the X or Y axis should include ALL of the possible highest education levels, on this axis add an axis title of Highest Education, use Calibri font size 12 for both title and labels
Either the X or Y axis should include percentages, the labels on this axis should start at 0% and end at 50% with an added axis title of Percentage, use Calibri font size 12 for both title and labels
Add data labels to your chart, so that the percentage each bar represents shows up outside the end of the bar, use Calibri font size 12
Copy the chart area and paste it in the Word doc as an editable chart it cannot be an image of the chart
WARNING: Total should not be included and no numbers should be in your chart, only percentages

After all, charts have been created and pasted into a Word doc, center them and make sure that the layout looks professional. Add your name, class, assignment, and date in the top left corner. Submit this as a Word file only.