I have problem with PHstat excel on mac.

Anyone can explain the problem and how to fix this?

A cell range is not from the active sheet. Many procedures require

that every cell range be located on the active sheet. Continue with procedure?

AutoSave OFF 9. CE ... FTMBA Home Insert Draw Page Layout Formulas Data Review View Automate PHStat ? Tell me Share Comments Data Preparation v Sampling v One-Sample Tests v Multiple-Sample Tests v Control Charts v 1 About PHStat Descriptive Statistics v Confidence Intervals v Two-Sample Tests (Unsummarized Data) v Probability & Prob. Distributions v Sample Size Two-Sample Tests (Summarized Data) v Regression v Decision-Making ? Help for PHStat X V fx School A B E G H I J K L M N P Q R S T U V W Tuition per ! Average Acceptance Graduates employed at Average starting salary 1 School year ($) GMAT score Rate (%) graduation (%) and bonus ($) 63675 729 10.7 79.3 153830 67516! 730 19.6 85.8 155058 66540 726 23.6 84.9 14747 W3 O VOUT A W N 67938 724 11.7 81.2 143565 66462! 728 20.1 82.8 141694 66540 737 62.8 153553 O 5 4 0 YOU A WN 6.0 Simple Linear Regression 66390 717 22.4 86.8 148997 - Data 68792! 720 14.1 77.3 5022 Y Variable Cell Range: DATA!$F$1:$F$38 10 64200 725 19.0 76.0 135988 X Variable Cell Range: DATA!$B$1:$B$38 11 63200 695 22.1 83.1 144799 First cells in both ranges contain labe 12 111 66588 710 23.1 82.1 145413 Confidence level for regression coefficients 95 % 13 12 61584 700 27.6 79.8 146252 14 13 61440 686 30.3 76.0 14028 - Regression Tool Output Options 15 141 57000 683 33.1 84.0 38864 Regression Statistics Table 16 15 55050 692 44.6 69.1 124417 ANOVA and Coefficients Table 17 16 55400 688 29.7 78.5 11583 Residuals Table 18 17 55474 692 33.3 75.2 126932 Residual Plot 19 18 51900 691 45.5 80.3 29587 Output Options- 20 19 53000 690 26.6 75.2 13182 Title: 21 201 50326 683 41.0 75.7 122791 22 21 46000 665 33.6 78.6 113515 Scatter Plot 23 22 47340 667 38.2 75.3 10926 Durbin-Watson Statistic 24 23 49800! 682 37.1 65.7 1 1116 Confidence Int. Est. & Prediction Int. for X = 25 24 45976; 662 38.6 60.7 108347 Confidence level for intervals: 26 25 37996 321 40.0 63.6 80249 27 47800 642 80249 Help OK Cancel 55.3 56.5 28 46860 641 54.9 68.4 10179 29 28 ! 49959 651 63.1 53.6 76455 30 291 38250! 632 64.3 60.0 86123 31 30 33328 623 58.5 94 9 73646 32 31 43290 322 55.7 18.9 75879 33 321 41804! 558 52.0 63.6 52190 34 33 49400 567 82.9 26.7 64891 35 34 33996. 498 33.7 54.2 102156 36 35 23020 482 90.2 61.8 55918 37 36 41490; 486 59.3 35.7 80000 38 371 _39100 545 94.5 42.6 53848 39 40 41 42 43 DATA + Point Accessibility: Good to go + 100%AutoSave OFF . GP ... 3 FTMBA Home Insert Draw Page Layout Formulas Data Review View Automate PHStat ? Tell me Share Comments Data Preparation Sampling v One-Sample Tests v Multiple-Sample Tests v Control Charts v About PHStat Descriptive Statistics v Confidence Intervals v Two-Sample Tests (Unsummarized Data) v Probability & Prob. Distributions v Sample Size v Two-Sample Tests (Summarized Data) v Regression v Decision-Making Help for PHStat 4 X fx School PHStat Add-in A cell range is not from the active sheet. Many procedures require that every cell range be located on the active sheet. Continue with procedure? No Yes DATA + Ready 12 Accessibility: Good to go + 100%AutoSave OFF . CP ... FTMBA Home Insert Draw Page Layout Formulas Data Review View Automate PHStat . Tell me Share Comments Data Preparation Sampling v One-Sample Tests v Multiple-Sample Tests v Control Charts v About PHStat Descriptive Statistics v Confidence Intervals v Two-Sample Tests (Unsummarized Data) v Probability & Prob. Distributions v Sample Size Two-Sample Tests (Summarized Data) v Regression v Decision-Making Help for PHStat A2 X V fx B C D E F G H J K L M N O P Q R S Simple Linear Regression Calculations b1, bo Coefficients W N Regression Statistics b1, bo Standard Error Multiple R #DIV/O! R Square, Standard Error 5 R Square 0.0000 F, Residual df 6 Adjusted R Square #DIV/O! Regression SS, Residual SS 7 Standard Error 0.0000 Observations Confidence level 95% 9 t Critical Value #NUM! 10 ANOVA Half Width bo #NUM! 11 df SS MS Significance F Half Width b1 #NUM! 12 Regression 0.0000 0.0000 0.0000 #NUM! 13 Residual 0.0000 #DIV/O! 14 Total 0.0000 15 16 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95% Upper 95% 17 Intercept 0.0000 0.0000 #DIV/O! #DIV/O! #NUM! #NUM #NUM #NUM 18 0.0000 0.0000 #DIV/O! #DIV/O! #NUM #NUM! #NUM! #NUM! 19 20 21 22 23 24 25 26 27 38 39 40 41 42 43 44 SLRData nuSLRWS DATA + Ready 12 Accessibility: Good to go + 100%