Feedback by UserVoice

How can we improve Excel for Mac?

Regression Data Must Be In Columns

Regression models generated from data in rows are incorrect. Additional independent variables are added with zeros for there parameters. The last two independent variables are populated incorrectly. To get a correct regression model solution I must arrange the data in columns.

Same thing happens with Excel 2015 for Windows. Data must be in columns. This was not the case with the previous release of Excel 2013.

It is a real pain to have copy and transpose the data into columns to get the correct regression model.

What will it take to get this fixed?

Donald Barar

5 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Donald Barar shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base