I don't know why my P value is #NUM!.

plz help me to know P value

T25 v : XV fx =T.DIST.2T(V24,48) G M N Q R W AA AB AC AD AE AF AG AH Al AK AL AM The data to the right shows State Rankings from Statistical Abstract of the United States of the violent crime rate per 100,000 people and the mean household income. The data is used to Income predict the crime rate based on the mean hosehold income. Test at the 5% level for a correlation between median income and crime rates. Find a 95% prediction interval for state that has a median income of $60,000. Crime Alabama 42,666 POINTS Out OF Alaska 68,460 661 Place scatter plot Here Step 1 Identify variable and parameter with variable and words FIND YOUR POINT ESTIMATOR CHOOSE YOUR CRITICAL VALUE Arizona 50,958 483 Income Critical Value Arkansas 38,815 529 Income vs. Crime Crime California 61,021 523 correlation coeffient between income and crime CALCULATE SIGMA CALCULATE MARGIN OF ERROR Colorado 56,993 1,000 SE = ME = Connecticut 68,595 256 800 y = -0.0011x + 463.46 Step 2 Identify Null Hypothesis, Alternative Hypothesis, (words and 1 Delaware 57,989 689 RX = 0.0025 600 algebraically) and Level of Significance CALCULATE CONFIDIENCE INTERVAL Florida 47,778 723 Georgia 493 400 Point Estimator + Margin of Error 50,861 200 . .. .. Ho : P=O There is no corrletion between income and crime Hawaii 67,214 273 There is a corrletion between income and crime Interval POINTS Out OF Idaho 47,576 239 10,000 20,000 30,000 40,000 50,000 60,000 70,000 80,000 0.05 Illinois 56,235 Income Indiana 47,966 Step 3 Check for normality lowa 48,980 random sample taken POINTS Out OF STATISTICAL INTERPRETATION Kansas 50,177 What is independent variable? Income POINTS Out OF residuals are random POINTS Out OF Kentucky 41,538 What is you dependent variable? Crime 13 normality exists Louisiana 43,733 730 What is you line of regression? V = -0.0011x + 463.46 2 Maine 46,581 118 What is r squared? 0.0025 0.3% 99.8% Step 4 Find sample statistic, test statistic and pvalue, Draw a picture. REAL WORLD INTERPRETATION Maryland 70,545 642 What is r ? -0.05 0.05 SE = 0.144157 4 Massachusetts 65,401 432 Describe the correlation. Moderate Positive Critical Value T -0.34684 POINTS Out OF Michigan 48,591 536 Describe the r2 0.3% of change in the the Income is due to the Value = #NUM! #NUM! 6 Minnesota 57,288 289 change in the Crime. The other 99.8% is due to dec % 7 Mississippi 37,790 291 other factors. 8 Missouri 46,867 choose from drop down 9 Montana 43,654 Predict crime rate for a state that has a median income of $30,000. 430.46 interpolation very confident 0 Nebraska 49,693 Predict crime rate for a state that has a median income of $50,000 408.46 interpolation very confident Nevada 56,361 Predict median income for a state that has a crime rate of 535 65036.36364 extrapolation not very confident New Hampshire 63,731 New Jersey 70,378 329 -0.0011x + 463.46 $4 New Mexico 43,508 664 535 = -0.0011x + 463.46 5 New York 56,033 414 71.54 = 0.0011x 6 North Carolina 46,549 65036.4 = $7 North Dakota 45,685 -3 - 2 -1 0 2 3 18 Ohio 47,988 POINTS Out OF 9 Oklahoma 42,822 10 Oregon 50,169 Pennsylvania 50,713 Step 5 Make a conclusion about null hypothesis POINTS Out OF Rhode Island 55,701 South Carolina 44,625 South Dakota 46,032 Step 6 Interpret you alternative hypothesis Tennessee 43,614 POINTS Out OF Texas 50,043 Utah 56,633 8 Vermont 52,104 124 9 Virginia 61,233 270 0 Washington 58,078 333 1 West Virginia 37,989 275 Wisconsin 52,094 291 wyoming 53,207 239 50