Results 1 to 2 of 2

Using Linear Regression to predict a future event / performance figure / speed figure

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-04-2014
    Location
    Nevada, USA
    MS-Off Ver
    2019
    Posts
    345

    Using Linear Regression to predict a future event / performance figure / speed figure

    Okay, so, I am not asking this question for a school project or for a friend. I’ll come straight out and say it – Yes! I have a gambling problem.
    My great love is for horses and horse racing. However, I tend to lose more-often than win. Thus, ideally, I am trying to reduce my losses – and for that, I need some help here.
    I need to figure out how a horse is likely to perform today – given its past racing history.
    Thus, the basic question I have for all you Excel experts is this – How do I use Linear Regression to predict the likeliest Speed Figure a given horse is likely to run today – given its past speed figure history?

    So, the attached Excel Spreadsheet (Excel 2010 version) contains the relevant data that I would use to ask the question.
    Column A contains today’s date.
    Column B contains the race number
    Column C contains the names of each horse in each race.
    Column D contains the dates on which each horse has raced.
    Column E contains the speed figure each horse earned on any given day that it raced.
    Column F contains the question I am asking based on each horse’s racing history.

    The real truth though, is that I am trying to understand Linear Regression – through a game I understand.

    Thank you in advance for all good answers.
    Attached Files Attached Files
    Last edited by Doofus1; 06-22-2017 at 01:41 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. converting a monthly figure with growth to an annual figure
    By venvitale in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-04-2015, 05:23 PM
  2. Using If/And Function to figure out Eligibility of Benefit at a Future Date
    By alauratag in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-02-2014, 01:44 PM
  3. Replies: 4
    Last Post: 02-03-2014, 08:05 AM
  4. Excel formula to figure out expiration date in the future
    By AQUANX4 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-05-2013, 09:05 AM
  5. Sum formula to exclude monthly budget figure when actual figure is entered
    By rocketmail in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-02-2013, 04:22 AM
  6. Cross Reference to a Figure actually showing figure, not just caption
    By mgaworecki in forum Word Formatting & General
    Replies: 2
    Last Post: 02-23-2012, 10:53 AM
  7. Calculating monthly sales figure required to make annual turnover figure
    By CatIsoSio Sky in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-27-2010, 04:42 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1