Chrome File Edit View History Bookmarks Profiles Tab Window Help G Q Tue Apr 19 5:44 PM M Inbox X M Inbox X Mana X 19 Saint X M Creat X Interv X HIST X #M Long X Ques X Chap X C Solve X Home X Scree X C ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fnewconnect.mheducation.co... Update : Analytics Assignment i Saved Help Save & Exit Submit Required information [The following information applies to the questions displayed below.] Chapman Realty Company is seeking your help in analyzing the performance of its realtors over the last four months. Part 1 of 9 During this time period the company's 12 realtors sold 99 properties (residential, commercial, and land) across six counties for a total of $30,637,161. Click here to download the Excel template, which you will use to answer the questions that follow. Files Click here for a brief tutorial on PivotTables in Excel. Click here for a brief tutorial on PivotCharts in Excel. Required: 1. Summarize each realtor's cumulative sales during the four-month period: a. Using PivotTable, calculate the cumulative sales for each realtor during the four-month period. b. Using PivotChart, create a bar chart that shows each realtor's cumulative sales during the four-month period. Save your completed worksheet to your computer and then upload it here by clicking "Browse." Next, click "Save." upload a response file (15MB max) Mc Graw Hill 19 astv AaChrome File Edit View History Bookmarks Profiles Tab Window Help G Q Tue Apr 19 5:44 PM M Inbox X M Inbox X Mana X 19 Saint X M Creat X 1 Interv X HIST X HM Long X Ques X Chap X C Solve X Home X Scree X C D ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fnewconnect.mheducation.co... Update : Analytics Assignment i Saved Help Save & Exit Submit 2 Required information [The following information applies to the questions displayed below.] Part 2 of 9 Chapman Realty Company is seeking your help in analyzing the performance of its realtors over the last four months. During this time period the company's 12 realtors sold 99 properties (residential, commercial, and land) across six counties for a total of $30,637,161. Click here to download the Excel template, which you will use to answer the questions that follow. Files Click here for a brief tutorial on PivotTables in Excel. Click here for a brief tutorial on PivotCharts in Excel. 1c. Which realtors had the third and fifth highest sales? How much did each of them sell during the four-month period? Third highest sold Fifth highest sold Mc Graw Hill astv AaChrome File Edit View History Bookmarks Profiles Tab Window Help G Q Tue Apr 19 5:45 PM M Inbox X M Inbox X Mana X 19 Saint X M Creat X Interv X HIST X #M Long X Ques X Chap X C Solve X Home X Scree X C D ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fnewconnect.mheducation.co... To * 0.> Update : Analytics Assignment i Saved Help Save & Exit Submit 3 Required information [The following information applies to the questions displayed below.] Part 3 of 9 Chapman Realty Company is seeking your help in analyzing the performance of its realtors over the last four months. During this time period the company's 12 realtors sold 99 properties (residential, commercial, and land) across six counties for a total of $30,637,161. Click here to download the Excel template, which you will use to answer the questions that follow. Files Click here for a brief tutorial on PivotTables in Excel. Click here for a brief tutorial on PivotCharts in Excel. 2. Summarize each realtor's cumulative sales by property type for the four-month period: a. Using PivotTable, calculate the cumulative sales by property type for each realtor during the four-month period. b. Using PivotChart, create a bar chart that shows each realtor's cumulative sales of each property type during the four-month period. Save your completed worksheet to your computer and then upload it here by clicking "Browse." Next, click "Save." upload a response file (15MB max) Choose File No file chosen Mc Graw 19 tv AaChrome File Edit View History Bookmarks Profiles Tab Window Help G Q Tue Apr 19 5:45 PM M Inbox X M Inbox X Mana X 19 Saint X M Creat X Interv X HIST X #M Long X Ques X Chap X C Solve X Home X Scree X C ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fnewconnect.mheducation.co... To * 0.> Update : Analytics Assignment i Saved Help Save & Exit Submit 4 Required information [The following information applies to the questions displayed below.] Part 4 of 9 Chapman Realty Company is seeking your help in analyzing the performance of its realtors over the last four months. During this time period the company's 12 realtors sold 99 properties (residential, commercial, and land) across six counties for a total of $30,637,161. Click here to download the Excel template, which you will use to answer the questions that follow. Files Click here for a brief tutorial on PivotTables in Excel. Click here for a brief tutorial on PivotCharts in Excel. 2c. Which realtor had the highest sales within each property type? In each case, how much did the realtor sell? Commercial Sold Land Sold Residential Sold Mc Graw Hill stv AaChrome File Edit View History Bookmarks Profiles Tab Window Help G Q Tue Apr 19 5:45 PM M Inbox X M Inbox X Mana X 19 Saint X M Creat X Interv X HIST X #M Long X Ques X Chap X C Solve X Home X Scree X C D ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253%252F%252Fnewconnect.mheducation.co... To * 0.> Update : Analytics Assignment i Saved Help Save & Exit Submit 5 Required information [The following information applies to the questions displayed below.] Part 5 of 9 Chapman Realty Company is seeking your help in analyzing the performance of its realtors over the last four months. During this time period the company's 12 realtors sold 99 properties (residential, commercial, and land) across six counties for a total of $30,637,161. Click here to download the Excel template, which you will use to answer the questions that follow. Files Click here for a brief tutorial on PivotTables in Excel. Click here for a brief tutorial on PivotCharts in Excel. 3. Summarize each realtor's cumulative sales by county for the four-month period: a. Using PivotTable, calculate the cumulative sales by county for each realtor during the four-month period. b. Using PivotChart, create a bar chart that shows each realtor's cumulative sales within each county during the four-month period. Save your completed worksheet to your computer and then upload it here by clicking "Browse." Next, click "Save." upload a response file (15MB max) Choose File No file chosen Mc Graw 19 istv AaChrome File Edit View History Bookmarks Profiles Tab Window Help G Q Tue Apr 19 5:45 PM M Inbox X M Inbox X Mana X 19 Saint X M Creat X Interv X HIST X #M Long X Ques X Chap X C Solve X Home X Scree X C D ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fnewconnect.mheducation.co... To * 0.> Update : Analytics Assignment i Saved Help Save & Exit Submit 6 Required information [The following information applies to the questions displayed below.] Part 6 of 9 Chapman Realty Company is seeking your help in analyzing the performance of its realtors over the last four months. During this time period the company's 12 realtors sold 99 properties (residential, commercial, and land) across six counties for a total of $30,637,161. Click here to download the Excel template, which you will use to answer the questions that follow. Files Click here for a brief tutorial on PivotTables in Excel. Click here for a brief tutorial on PivotCharts in Excel. 3c. Which realtors had the highest sales within Buncombe, Henderson, and Polk counties? In each case, how much did the realtor sell? Buncombe Sold Henderson Sold Polk Sold Mc Graw tv N AC AaChrome File Edit View History Bookmarks Profiles Tab Window Help G Q Tue Apr 19 5:46 PM M Inbox X M Inbox X Mana X 19 Saint X M Creat X Interv X HIST X #M Long X Ques X Chap X C Solve X Home X Scree X C ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fnewconnect.mheducation.co... To * 0.> Update : Analytics Assignment i Saved Help Save & Exit Submit Required information [The following information applies to the questions displayed below.] Part 7 of 9 Chapman Realty Company is seeking your help in analyzing the performance of its realtors over the last four months. During this time period the company's 12 realtors sold 99 properties (residential, commercial, and land) across six counties for a total of $30,637,161. Click here to download the Excel template, which you will use to answer the questions that follow. Files Click here for a brief tutorial on PivotTables in Excel. Click here for a brief tutorial on PivotCharts in Excel. 4. Summarize each realtor's cumulative number of sales transactions during the four-month period: a. Using PivotTable, calculate the cumulative number of sales transactions for each realtor during the four-month period. b. Using PivotChart, create a bar chart that shows each realtor's cumulative number of sales transactions during the four-month period. Save your completed worksheet to your computer and then upload it here by clicking "Browse." Next, click "Save." upload a response file (15MB max) Choose File No file chosen Mc Graw 19 astv AaChrome File Edit View History Bookmarks Profiles Tab Window Help G Q Tue Apr 19 5:46 PM M Inbox X M Inbox X Mana X 19 Saint X M Creat X 1 Interv X HIST X HM Long X Ques X Chap X C Solve X Home X Scree X C ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fnewconnect.mheducation.co... Update : Analytics Assignment i Saved Help Save & Exit Submit 8 Required information [The following information applies to the questions displayed below.] Part 8 of 9 Chapman Realty Company is seeking your help in analyzing the performance of its realtors over the last four months. During this time period the company's 12 realtors sold 99 properties (residential, commercial, and land) across six counties for a total of $30,637,161. Click here to download the Excel template, which you will use to answer the questions that follow. Files Click here for a brief tutorial on PivotTables in Excel. Click here for a brief tutorial on PivotCharts in Excel. 4c. Which realtor completed the second highest number of sales transactions during the four-month period? How many properties did the realtor sell? Sales transactions Sold Mc Graw stv AaChrome File Edit View History Bookmarks Profiles Tab Window Help G Q Tue Apr 19 5:46 PM M Inbox X M Inbox X Mana X 19 Saint X M Creat X Interv X HIST X #M Long X Ques X Chap X C Solve X Home X Scree X C D ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fnewconnect.mheducation.co... To * 0.> Update : Analytics Assignment i Saved Help Save & Exit Submit 9 Required information [The following information applies to the questions displayed below.] Part 9 of 9 Chapman Realty Company is seeking your help in analyzing the performance of its realtors over the last four months. During this time period the company's 12 realtors sold 99 properties (residential, commercial, and land) across six counties for a total of $30,637,161. Click here to download the Excel template, which you will use to answer the questions that follow. Files Click here for a brief tutorial on PivotTables in Excel. Click here for a brief tutorial on PivotCharts in Excel. 5. Based on your findings in requirements 1-4, Who were the top performers? Total sales Sold Commercial segment Sold Land sales Sold Residential sales Sold Mc Graw tv Aa