Metropolitan Area Albany, NY Albuquerque, NM Appleton, WI Atlanta, GA Austin, TX Baltimore, MD Birmingham, AL Boise City, ID Boston, MA Buffalo, NY Calgary, AB Carleston, SC Charlotte, NC Chattanooga, TN Chicago, IL Cincinnati, OH Cleveland, OH Columbia, SC Columbus, OH Dallas, TX Dayton, OH Denver, CO Detroit, MI Duluth, MN Edmonton, AB Fargo, ND Fayetteville, AR Fort Lauderdale, FL Fort Myers, FL Fort Wayne, IN Fort Worth, TX Gainesville, FL Grand Rapids, MI Greensboro, NC Greenville, SC Halifax, NS Harrisburg, PA Hartford, CT Rating 64.18 66.16 60.56 69.97 71.48 69.75 69.59 68.36 68.99 66.10 66.04 66.54 66.41 62.64 65.69 73.34 70.63 66.07 68.14 68.59 65.82 74.09 61.38 60.65 69.37 63.45 61.88 65.59 61.69 63.45 65.34 60.37 63.01 70.95 64.53 61.50 66.07 62.35 Gender Majority RAND() M After using the RAND() function, sort M the data. You will then use the first 30 F elements in the list as your sample. F M F F F F F F M M F F M M M F F F F F F F F M M M M M M F M F M F M Honolulu, HI Houston, TX Huntsville, AL Indianaoplis, IN Jackson, MS Jacksonville, FL Johnson City, TN Kansas City, MO Knoxville, TN Lexington, KY Little Rock, AR Long Island, NY Los Angeles, CA Louisville, KY Madison, WI Memphis, TN Miami, FL Milwaukee, WI Minneapolis, MN Montreal, PQ Nashville, TN New Orleans, LA New York, NY Newark, NJ Norfolk, VA Oakland, CA Oklahoma City, OK Omaha, NE Oralndo, FL Orange County, CA Ottawa, ON Philadelphia, PA Phoenix, AZ Pittsburgh, PA Portland, ME Portland, OR Raleigh, NC Reno, NV Richmond, VA] Riverside, CA 70.98 73.94 60.34 71.01 63.36 69.02 65.09 66.73 72.74 66.95 61.41 69.56 64.97 72.68 64.08 67.01 72.30 68.93 73.72 65.53 70.19 71.36 65.72 62.89 68.40 66.16 65.94 68.93 71.04 72.43 62.51 70.54 73.37 72.99 65.31 70.88 74.03 60.75 66.79 65.72 F F F F F M M F F M M F F M M F F F M M F F F M M M F F F F F F M M M M M F F F Roanoke, VA Rochester, NY Sacramento, CA Salt Lake City, UT San Antonio, TX San Diego, CA San Fancisco, CA San Jose, CA Santa Barbara, CA Sarasota, FL Scranton, PA Seattle, WA Spokane, WA St. Louis, MO Syracuse, NY Tampa, FL Toledo, OH Toronto, ON Tucson, AZ Vancouver, BC Washington, DC West Palm Beach, FL 63.30 70.19 64.52 75.57 69.12 71.61 72.61 70.69 62.01 66.41 63.83 74.57 66.76 69.18 70.16 74.50 64.30 74.00 65.66 72.05 74.82 67.04 F F F M F M F F M M M M F F M M F M F M M F Population Mean Std Dev Prop (M) Sample You will need to count the number of "M" responses and the number of esponses and the number of "N" responses. Construct a confidence interval for the following sample of 100 Lloyds customers with a population standard dev Amount Spent 72 91 74 115 71 120 37 96 91 105 104 89 70 125 43 61 102 85 26 88 80 76 70 46 79 71 78 55 104 62 84 78 54 47 109 105 65 122 112 Sample Size Sample Mean Pop Std Dev Confidence Coeff Level of Significance Marginn of Error Point Estimate Lower Limit Upper Limit 20 0.95 59 100 85 82 60 65 98 61 42 114 93 110 95 62 119 68 98 89 118 63 87 72 92 89 72 46 108 63 91 86 93 84 124 75 82 56 58 64 72 97 66 80 85 75 99 112 93 76 76 89 99 113 68 80 52 90 86 95 57 71 84 rs with a population standard deviation of 20. Below are the credit card balances for a sample of New Balance customers Computer the point estimate and the m an interval estimate of a population mean (population std. dev. unknown). You will need to run the Descriptive St confidence interval. (Use Descriptive Statistics from the Data Analysis Tool Pak) NewBalance 9430 7535 4078 5604 5179 4416 10676 1627 10112 6567 13627 18719 14661 12195 10544 13659 7061 6245 13021 9719 2200 10746 12744 5742 7159 8137 9467 12595 7917 11346 12806 4972 11356 7117 9465 19263 9071 3603 16804 13479 14044 6817 6845 10493 615 13627 12557 6232 9691 11448 8279 5649 11298 4353 3467 6191 12851 5337 8372 7445 11032 6525 5239 6195 12584 15415 15917 12591 9743 10324 mputer the point estimate and the margin of error for will need to run the Descriptive StatUse a 90% Response Yes No Yes Yes No No No Yes Yes Yes No No Yes No No Yes No Yes Yes No No Yes No No No No No Yes No No Yes Yes No No No Yes No No No No Yes No No No Interval Estimate of a Population Proportion Sample Size Response of Interest Count for Response Sample Proportion 900 Yes Confidence Coefficient z Value 0.95 1.96 Standard Error Margin of Error Point Estimate Lower Limit Upper Limit No Yes Yes No No Yes No Yes No Yes Yes No No Yes No Yes No No No No Yes No Yes Yes No No No Yes No Yes Yes Yes Yes No No No No Yes No No Yes Yes No No Yes No No No Yes No No No No No No Yes No Yes Yes No Yes Yes No No No Yes No Yes No Yes No No No No No No No Yes No Yes Yes Yes Yes No Yes No Yes Yes No No Yes No No No Yes No No Yes No No No Yes No Yes No Yes Yes Yes Yes Yes Yes Yes No Yes No No Yes No Yes No Yes Yes Yes No Yes No No Yes No No No Yes No No Yes Yes No Yes No Yes No No No No No No Yes Yes No Yes No No No Yes No No No Yes No Yes Yes Yes Yes Yes No Yes Yes Yes Yes No No No No No No No Yes Yes No Yes Yes No No Yes No No No Yes No Yes No No No No Yes No Yes Yes Yes No No No Yes No Yes No Yes No Yes No No No No No No No No No No Yes No Yes No No No No Yes No Yes Yes Yes No Yes No No No Yes Yes No No Yes No No No Yes Yes No Yes Yes Yes Yes No Yes Yes No No Yes Yes No Yes No No Yes Yes No No No Yes No No No No Yes No Yes No Yes No Yes Yes Yes Yes No No Yes Yes No Yes Yes No Yes Yes Yes Yes Yes No No No Yes Yes Yes Yes Yes Yes No No No No No Yes Yes Yes No No No No No Yes Yes Yes No No Yes No Yes No No Yes Yes Yes No Yes Yes Yes No No Yes Yes No No No Yes Yes Yes No Yes No No No No No No No Yes No No Yes Yes Yes No No No Yes No No Yes No Yes Yes No No Yes No No Yes No No No No No Yes No No Yes No Yes Yes Yes Yes Yes Yes Yes No No No Yes Yes Yes Yes Yes Yes No Yes No No No No Yes No No No Yes Yes Yes No Yes Yes No No No Yes No No Yes Yes No Yes No Yes No Yes Yes Yes Yes No No Yes No Yes No No No No Yes No No Yes Yes No Yes No Yes No Yes No No No No No No Yes Yes No No No No No Yes No No No No No Yes Yes Yes No No Yes Yes Yes No No Yes No Yes No Yes Yes No No No Yes No No Yes Yes No Yes Yes Yes No Yes No No No Yes No No Yes No Yes Yes Yes Yes No No No Yes Yes No Yes No No No Yes No Yes No Yes No Yes No No No Yes Yes Yes Yes No Yes Yes Yes Yes No Yes No No Yes No Yes Yes Yes Yes No Yes Yes No No No No Yes No No Yes No No No No No No No No No No Yes Yes Yes No Yes No No Yes No No No No Yes No Yes Yes No No No No Yes Yes Yes No Yes No No No No Yes No No Yes No Yes No Yes No No No No Yes No No No Yes Yes Yes Yes No Yes Yes No No No Yes No Yes Yes No No No No No No Yes No No Yes Yes Yes No No No Yes No No Yes Yes Yes No Yes Yes No No No Yes No Yes No No No No No Yes No No Yes No No Yes Yes No No Yes Yes Yes No Yes Yes No No Yes Yes No Yes Yes Yes No No No No No Yes No No Yes No Yes No Yes Yes No No No No No No No No No No Yes Yes No No No No Yes Yes Yes Yes No No Yes Yes Yes No No No Yes Yes Yes No Yes Yes Yes No Yes No Yes No Yes Yes Yes Yes No Yes Yes No No No No Yes Yes No Yes Yes No No No No Yes No Yes No No No No Yes Yes Yes Yes No Yes No No Yes Yes No Yes No Yes No Yes Yes Yes Yes Yes No Yes No No No No No No No No No No No No Yes Yes No Yes Yes Yes No No No Yes No No No Yes No No Yes No No No Yes Yes Yes Yes Yes No No No Yes No No Yes No No No No Yes No No No No Yes No Yes Yes Yes Yes Yes