Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculating In Excel
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 file with hyperlinks takes a long time to open over the network | Links and Linking in Excel | |||
Multiple Excel versions. | Excel Discussion (Misc queries) | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
Calculating tvl time in Excel 2000 Rev.9.2720 | Excel Worksheet Functions | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |