Business Driven Technology 6th Edition by Paige Baltzan

Exercise 154

Gathering Data
You have just accepted a new job offer from a firm that has offices in San Diego, Los Angeles, and San Francisco. You need to decide which location to move to. Because you have not visited any of these three cities and want to get in a lot of golf time, you determine that the main factor that will affect your decision is weather.
Go to www.weather.com and locate the box in which you can enter the city or zip code for which you want information. Enter San Diego, CA, and when the data appear, click the Averages and Records tab. Print this page and repeat this for Los Angeles and San Francisco. You will want to focus on the Monthly Average and Records section on the top of the page.
Project Focus
1. Create a spreadsheet to summarize the information you find.
2. Record the temperature and rainfall in columns, and group the cities into four groups of rows labeled Average High, Average Low, Mean, and Average Precipitation.
3. Fill in the appropriate data for each city and month.
4. Because rain is your greatest concern, use conditional formatting to display the months with an average precipitation below 2.5 inches in blue and apply boldface.
5. You also want to be in the warmest weather possible while in California. Use conditional formatting to display the months with average high temperatures above 65 degrees in green and apply an italic font face.
6. Looking at the average high temperatures above 65 degrees and average precipitation below two inches, to which city do you think you should relocate Explain your answer.