Solve software problem quickly Share experience to help others Improve the ability of solving problem
How to Calculate MSE in Excel

11/15/2011 07:44 by KevinHan

First answer posted by PollyP at 11/15/2011 07:44
Add Your Answer
10~1000 characters in length CAPTCHA:
3 Answers
  • PollyP
    1. Type the data points in column A, starting in cell A1.

    2. Type the estimated data points in column B, starting in cell B2.

    3. Type "=A1-B1" in cell C1, then grab the fill handle, which is the little black square at the bottom right of the cell. Drag the fill handle down the column to match the last row of data you entered in columns A and B.

    4. Type "=C1^2" into cell D2 then grab the fill handle. Pull the fill handle down the column to match the last row you filled in columns A through C.

    5. Click the first empty cell in column D, then click the sigma symbol in the Ribbon. This action adds the sum of the square of the errors.

    6. Calculate the MSE from the entered data. Click cell E1, then type "=." Click the summation cell, then type "/." Type the number of data points that you entered in column A. Press Enter to get the MSE.

  • Was this answer helpful? 00 · 11/15/2011 07:44
  • Anonymous user
  • have you tried turning it off and on again
  • Was this answer helpful? 00 · 05/28/2014 02:28
  • Anonymous user
  • 1991 2634 1992 3169 1993 3301 1994 3754 1995 3834 1996 5117 1997 6448 1998 7908 1999 9213 2000 11502 2001 10791 2002 10022 2003 8342 2004 10453 2005 10784 2006 10718 2007 12460 2008 13262 2009 8772 2010 10431
  • Was this answer helpful? 00 · 03/30/2016 04:45
Add Your Answer
10~1000 characters in length CAPTCHA:
Related Questions
Q:How To Calculate Mortgage Payments in Excel

A: Start a new, blank workbook in Excel. In Excel 2007, click the "Office" button and click "New"; then click "Microsoft Online." In Excel 2003...(more)

Q:How to Use the Round Up Calculation in Excel

A: Enter the data that you want to round into a cell. Determine how many decimal places you want the function to round to. For example, if yo...(more)

Q:How to Calculate Business Quarters in Excel Not Based on Calendar Year

A: Open a new workbook in Excel and enter a list of random dates that can be used for testing. You can copy these example dates to your sheet b...(more)

Q:How to Use the Median Function in Excel

A: Launch Excel to start with a blank spreadsheet or open an existing workbook with a list of numbers. Enter numbers in a column, if you are ...(more)

Q:How to Calculate the Median of Shaded Cells in Excel

A: Open Excel and the worksheet for which you want to calculate the median. Click on the cell where you want Excel to enter the median result...(more)

Added Successfully!


Are you sure to delete your answer?



Are you sure to choose it as the best answer?



Voted Successfully!


You can't vote for yourself


You can't choose your own answer