Next |
|
Let's assume that the population increases by 7% over each 10 year period. That means in 10 years, the population will be 1.07 times bigger. If you click in cell C2 and type =B2*1.07 you will get the population anticipated in Overshoe in 10 years (It should be 5350). Use the "FILL RIGHT" choice in the CALCULATE menu (or use "Command" + "R") to do the rest of the years for Overshoe. Now, if you click on cell C2 and drag down to cell C5, you can use the FILL DOWN choice under the Calculate menu to do the same for the other towns in 2010. Then use FILL RIGHT to do the rest of the years for the other towns. Now, if you are predicting the size of a market for an area, you might want to make some assumptions. Let's say 90% (0.9) of all people in the county have telephones, 40% (0.4) have Cell Phones and 15% (0.15) have Satellite TVs. If you multiply the population by 90%, you can guess how many people have TVs in the county. This is what is set up in column B below the population (CUSTOMER PREDICTIONS).
Now it's your turn to make some guesses. Use the fill right command to predict how many people will use TV, Cell Phones and Sat TV in the future. You will have to FILL RIGHT the % lines (ANTICIPATED USAGE) for this to work. Now that you have this in place, you can modify your percentages for the future. Do you think the percentage of people with Cell Phones will go up over time? Then change the percentages and see what happens. How about TVs? Satellite TVs? This is shows some of the real power of a spreadsheet. |
Now, open the file called STEP AND TRACK. Some employers pay
their employees based on how long they have been in the profession (the
STEP) and by what kind of education they have (the TRACK). Often the scale
is based on a base salary which in in STEP 1 TRACK 1. Let's assume that
each step increases your salary by 5% and each track increases it by 6%.
So, cell B3 would be =B2 * 1.05, and cell C2 would be =B2 * 1.06. Now fill
in the rest of the document so that you find the salary for each of the
other places on the grid. Format the cells as CURRENCY. The highest step
and track should be $44011.77. Now, see what happens when you increase the
base to 25,000. By how much does the highest salary go up? Now try it with
a base of $30,000. Businesses use spreadsheets to predict the cost of salary
changes for their employees. Spreadsheets can be used whenever a large number
of calculations need to be done.
ASSIGNMENT 1. Open the Test Scores spreadsheet and follow the instructions on page 2 of this section to add a row of formatted averages.
2. Follow the instructions for the County Population file so that you can show predictions of future population and their TV, Cell Phone and Satellite TV usage.
3. Open the file STEP AND TRACK and make the changes as described in the text. Fill in the grid and then show what happens when the base salary is increased to $25,000 and $30,000. |
Next |