Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Spreadsheet Assignment
I have an assignment that I'm not quite understanding how to do, and would like some clarification. I would appreciate anyone's help please. Here goes:
This is an Excel Spreadsheet Assignment. The directions: 1. "Modify a spreadsheet to "include percentage use calculations of Internet use for shopping over the Internet for age, education level, and income category." (Only the Education Level Section's %'s are given). 2. "Create appropriate graphs to illustrate how the distribution of use of the Internet for shopping varies across age, income, and education level categories." For example: Section1 Education Level/ Yes Have Used / No Have Not Used /% Using Internet to Shop/Pay Bills ----------------------------------------------------------------------------------------- Less than HS / 598824 / 32354711 / 1.8% HS Grad / 5104952 / 60930000 / 7.7% Some College/No Degree/ 6613400 / 32290000 / 17.0% Assoc. Degree / 7840540 / 38855612 / 16.8% Bach. Degree / 9581979 / 22830000 / 29.6% Masters Degree or Higher/ 5196040 / 10280934 / 33.6% For the above section, the %'s are given, but for the next two sections (2nd section: Age), (3rd section: Household Income), the %'s are not given. For example: Section2 Age / Yes / No / (this area is blank) ------------------------------------------------------------------------------------- 10-14 / 557160 / 19646353 / blank 15-19 / 1607513 / 18251159 / blank 20-24 / 2670194 / 15597505 / blank and it continues all the way to age 75 and older. Section 3: Household Income / Yes / No / (this area is blank) ------------------------------------------------------------------------------------ Less than $5000 / 285666 / 4960488 / blank $5000 to $7499 / 152549 / 4727749 / blank $7500 to 9999 / 95264 / 4833534 / blank and it continues all the way to $75000 or more. So I would like to know how: 1. "Modify a spreadsheet to "include percentage use calculations for age, education level, and income category." (Only the Education Level Section's %'s are given). 2. "Create appropriate graphs to illustrate how the distribution of use of the Internet for shopping varies across age, income, and education level categories." |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Big problem with excel recalculating spreadsheet | Excel Discussion (Misc queries) | |||
Can Excel 97 read Excel 2003 simple spreadsheet? | Excel Discussion (Misc queries) | |||
Excel 2K3: Opening a spreadsheet, also opens book1.xls? | Excel Discussion (Misc queries) | |||
Excel 2K3: Opening spreadsheet, also opens book1.xls? | Setting up and Configuration of Excel |