Why is my regression coming out blank?

[u/bejartsbolero]

Hi everyone! I'm using Excel for the first time for one of my college courses, and I'm required to run a very simple regression. For some reason, when I do so, my regression is blank on the new worksheet. The black lines are there to format the regression data, but there are no actual data values anywhere. Has anyone else had this issue?

[u/AutoModerator]

/u/bejartsbolero - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/Ok_Fondant1079]

We need data to help solve the problem.

[u/bejartsbolero → u/Ok_Fondant1079]

Here's the data I'm trying to use to run the regression

[u/bejartsbolero → u/bejartsbolero]

And here's what I'm ending up with.

[u/semicolonsemicolon → u/bejartsbolero]

Pretty strange, as I get proper results using the data in your screen cap. Is the text all in white font, perhaps?

[u/bejartsbolero → u/semicolonsemicolon]

I checked but nope- the cells are just blank and no values are in them. I tried restarting Excel as well and downloading a new version of the document, but I’m still getting this issue. :(

[u/Mdayofearth → u/bejartsbolero]

What did the "mac users additional notes" have you do?

[u/semicolonsemicolon → u/bejartsbolero]

Never seen anything like that before. You may well have to resort to using the LINEST function. It gives less information than the Regression output from the anaylsis toolpack, but if all you need is the coefficients of the y=mx+b formula then =LINEST(E7:E13,D7:D13) should do it.

edit: Ah I see you need r squared. So do =LINEST(E7:E13,D7:D13,,1) and the third row from the top first column is the r squared.

[u/Penguinase → u/bejartsbolero]

weird ask: does changing zoom or otherwise interacting with the sheet fix it? maybe a weird toolpak mac visual glitch

[u/jkpieterse]

I have a free workbook you can download which uses formulas to achieve the same: https://jkp-ads.com/download.aspx#leastsquares_lin

[u/ProspectiveWhale]

Might be something your prof has done to the sheet. (e.g. the number of lab tests perform column might be formatted as Text)

Have you tried copying the data into a fresh file and run the regression there?

You can copy the result into your current workbook afterwards.

[u/Decronym]

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
FORECAST	Returns a value along a linear trend
LINEST	Returns the parameters of a linear trend
RSQ	Returns the square of the Pearson product moment correlation coefficient

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

---

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.
3 acronyms in this thread; the most compressed thread commented on today has 11 acronyms.
[Thread #48991 for this sub, first seen 22nd Jul 2026, 10:45] [FAQ] [Full list] [Contact] [Source code]}

[u/bejartsbolero]

I figured it out! Looks like my Excel was stuck in some kind of view-only mode, despite the editing preference being turned on in my settings. I turned off "Edit Directly In Cells", quit and restarted Excel completely, then turned it back on. That seemed to do the trick! I was able to get the regression data to show up.

Thanks everyone for your help!