prediction

I have a combobox on a userform that pre-selects an item if it thinks it knows what the user is going to select, based on a very simple prediction that I put together. If it guesses wrong, then of course the user needs to find the correct item they want. Most users are using a keyboard to make...

Hi everyone, I have recently been asked to make changes to a sales forecast. I've never done a task like this before but I would like to make a 5 year sales projection based on historical data from 2010-2016. Every company deals with different items, and so, it becomes difficult to follow...

Dear MrExcel community, Is there any easy and automatic way to compute predictions including confidence intervals after a multiple regression using the Analysis Toolpak? Also, the analysis toolpak regression tool reports an error whenever I have missing data points in my range selection. What...

I am wondering if its possible to write a macro that can find a relationship between columns in the worksheet found on the link below and make possible forecasts based on the relationship. https://www.dropbox.com/s/06hpjgcxuh61vkg/FIND%20A%20RELATIONSHIP.xlsx?dl=0 The worksheet has two...

I'm looking at a consortium of databases which are all representative of the country (little to no skew in each database). Adult population in the country is 48m. The databases in order of size: 19m 12m 4m 4m 4m 3m 1m 0.5m 0.5m I'm trying to calculate the net number of records I'm likely to...

Hi All, I apologise if this question has been asked before, I've tried searching for an answer to no avail. I'm trying to estimate data for a year that has not ended yet. Ok, let's say I have a dataset of unit orders from 2008 to August of current year. I want to build a table and chart that...

Hello All, I'm trying to create an excel formula that takes the current PC system date, compares it with a list (4 years worth) of events matched with time/date and produces the most frequent event for the PC system date. A macro button would be used to trigger the formula Example: PC System...

Hello, I have recently been wondering about this one particular problem. It's about presidential elections in the United States. For those not familiar with how they are conducted, here is how it goes: For each of the fifty states there is a number of presidential electors assigned relative to...

Hello, I am working a new job that requires a lot of Excel use. So far, this site has been incredibly helpful. I'm graphing revenue over time from 2012 and 2013 and I want to know if and when the lines will intersect. The x-axis is dates (e.g. July 1-10) and the y-axis has total revenue (e.g...