PHStat Troubleshooting

Frequent Visitor

I have used PHStat within excel all semester and only these last two weeks have problems arisen.

 

My professor linked a sheet inside one of our quizzes. I open the sheet, but whenever I try to conduct a simple linear regression I receive the pop up:

"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?"

If I select no, it cancels the action. When I select yes, it prompts me with another pop up:

"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?"

I select yes:

"Problem encountered when creating a copy of the regression data. Correct errors and rerun procedure." The sheet then reverts to the original table. I have tried deleting and installing PHStat again. 

 

Microsoft Excel for Mac version: 16.55

device version: macOS Monterey 12.0.1

1 Reply
I have the same problem (only when performing regression) and I only encountered this in the past 4 months. I hope someone provides a clear solution here.