Case Study Look at the data set in the attached file. It contains information about average January temperature (JanTemp), latitude (Lat), and longitude (Long) in 56 different cities. Undertake the following analysis.
(a) Create a scatter plot between temperature and longitude
(b) Find the correlation coefficient between temperature and latitude. Is it significant? Positive? Strong?
(c) Build a regression model with temperature as an output (dependent) variable and latitude and longitude as the input (independent) variables. Include a screenshot of the analysis results and explain what percentage of variance in temperature is captured by the model?
(d) Interpret the results and also point out the potential limitations of this analysis.
Sheet1 CityJanTempLatLong Mobile, AL4431.288.5 Montgomery, AL3832.986.8 Phoenix, AZ3533.6112.5 Little Rock, AR3135.492.8 Los Angeles, CA4734.3118.7 San Francisco, CA4238.4123 Denver, CO1540.7105.3 New Haven, CT2241.773.4 Wilmington, DE2640.576.3 Washington, DC3039.777.5 Jacksonville, FL453182.3 Key West, FL652582 Miami, FL5826.380.7 Atlanta, GA3733.985 Boise, ID2243.7117.1 Chicago, IL1942.388 Indianapolis, IN2139.886.9 Des Moines, IA1141.893.6 Wichita, KS2238.197.6 Louisville, KY273986.5 New Orleans, LA4530.890.2 Portland, ME1244.270.5 Baltimore, MD2539.777.3 Boston, MA2342.771.4 Detroit, MI2143.183.9 Minneapolis, MN245.993.9 St. Louis, MO2439.390.5 Helena, MT847.1112.4 Omaha, NE1341.996.1 Concord, NH1143.571.9 Atlantic City, NJ2739.875.3 Albuquerque, NM2435.1106.7 Albany, NY1442.673.7 New York, NY2740.874.6 Charlotte, NC3435.981.5 Raleigh, NC3136.478.9 Bismarck, ND047.1101 Cincinnati, OH2639.285 Cleveland, OH2142.382.5 Oklahoma City, OK2835.997.5 Portland, OR3345.6123.2 Harrisburg, PA2440.977.8 Philadelphia, PA2440.975.5 Charleston, SC3833.380.8 Nashville, TN3136.787.6 Amarillo, TX2435.6101.9 Galveston, TX4929.495.5 Houston, TX4430.195.9 Salt Lake City, UT1841.1112.3 Burlington, VT74573.9 Norfolk, VA323776.6 Seattle, WA3348.1122.5 Spokane, WA1948.1117.9 Madison, WI943.490.2 Milwaukee, WI1343.388.1 Cheyenne, WY1441.2104.9