1 Normal 1 No Spac.... Heading 1 Subtitle Subtle Em... Emphasis Intense The foll
ID: 287325 • Letter: 1
Question
1 Normal 1 No Spac.... Heading 1 Subtitle Subtle Em... Emphasis Intense The following are the average monthly temperature for the two cities: Month January February March April May June San Francisco Temp "C) St. Louis Temp (c) 9.2 10.5 0.1 1.5 13.2 14.6 16.3 17.1 17.1 17.7 15.8 12.7 10.1 12.7 17.9 23.4 25.6 24.9 20.8 14.7 6.7 1.6 August September October November December You will need to enter the data in the table-to your Microsoft excel Spreadsheet. You could copy and paste the data from this file to your Excel spreadsheet. 1. Plot the data as a line graph in Microsoft Excel. Make sure to label axes include a legend which specifies what data belongs to each city, and provide a chart title. Since you have entered this data all ready into Microsoft Excel you are now going to use the average formula to calculate the average for each city. After you find the average in degrees Celsius you need to convert this value into Fahrenheit. Find the formula in your book or online to convert Celsius to Fahrenheit and use Excel to calculate the number. What is the average annual temperature in Celsius and Fahrenheit of San Francisco C The annual range of temperature is calculated by subtracting the lowest average monthly temperature from the highest average monthly temperature. Use Excel to calculate these numbers. What is the annual range of temperature for San Francisco 2. F and St. Louis? C F 3. C St. Louis? 4. In what two seasons ( seasons meaning summer, spring, fall, and winter) do the maximum differences in temperature occur between these two cities. To get this answer look at the months where the gaps between the two graphs are the largest or in your table where the numbers gaps are largest. Then correlate the months to the seasonS Why do St. Louis and San Francisco exhibit these different temperature patterns? Hint: Use Google Earth to see where St. Louis and San Francisco are located. Are they at the same latitude? If so what other factor accounts for difference in temperature patterns.Explanation / Answer
2 For san franFranc 13.84 C is the avg temperature. i.e., 56.91F
For st. Louis, 12.96 C is the temperature avg and in farenheit, 55.32 F
3. San Francisco- highest temperature- 11.7
Loeest is 9.2
Annual range of temperature- 2.5°C
St.louis- highest- 25.6
Lowest is -0.1
Annual range- 25.7°C
4. In spring and start of winter in December, difference is observed more between the two cities
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.