This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I'm trying to use the LINEST function in excel to do some linear regression analysis. When doing so, the slope comes out fine, but when i expand it by selecting 5x2 square and control+U then command+enter, i get #VALUE! as the result. The selected Y and Y range selected in the original cell of the function change. So in the first linest function the known y is B2:B7 the known x is A2:A7 but then the rest are shifted over. I don't know how to solve this problem, and the online chat with screen take over have not worked. This is shown in the attached screenshots. The slope should be .282 but is wrong because the function is changed. PLEASE HELP!!
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
On my Mac computer, I enter the array formula using
Ctrl + Shift + Enter.
Works ok for me.