statistics

I have a table which has 8 Columns. I have data put in weekly for the last 3 years with the example being below. What i want is a formula that will predict what the next 6 months of data would be in rows ranging from batch 103 onwards. I need a simple formula with cell references that take into...

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...

Hi there, I have a query, hope someone can assist: I am trying to work out how to index the following as I am trying understand contribution to market: Market 1: Product A: Sub Product X: Total = 20000 2500...

I currently have a table in access with the following form: <tbody> GROUP VALUE A 1 A 2 A 3 A 4 A 5 B 6 B 7 B 8 B 9 B 10 C 11 C 12 C 13 C 14 C 15 </tbody> I am trying to create a query that will generate the following data broken down at the group level...

I'm running analysis on an Audit that has been distributed over the course of a year. There are currently about 40 or so different audits. Each audit contains 90 questions. When the audit was first published, the results we were getting were skewed. For instance, many of the answers came back at...

Hi Everybody. Thanks for your time. New guy here. I tried the site's search and found some similar questions with replies, but the solution links are no longer working. Hoping some kind generous Excel wiz might help with a formula for reporting productivity rate with an eye on daily average...

I have multiple workbooks that are used by train stations to record times or trains arriving and departing, each of these workbooks contains the times and train numbers and then saves it under the date completed along with the stations name. I am trying to work out the best way to consolidate...

Hello, I have an Excel-worksheet with data of people whom I called on their telephone (for a non-profit survey, members/supporters of a charity organization) Simplified, it looks like this: <tbody> Person ID (person that I called) Call Date Comment number of calls 2005002 2014-10-01 10:20...

Hi all, My question here is two-fold: Firstly, I have been asked to statistically analyse the customer satisfaction results for a pilot which has two groups - One, where the customer is asked a question by a receptionist before they are routed to the correct department; the other where they are...

Summary Question I am trying to use LINEST to calculate the linear regression output for selected data points in a table. The selection of the data points is being determined by a conditional array. Here's an example of the formula: LINEST(IF(D2:D10000=2,E2:E10000),IF(D2:D10000=2,E2:E10000))...

I've got the task to find out the repeat customer rate per year: Customers that have purchased more than once / unique customers I have no problems finding out the number of unique customers; I've got a customer table which counts the date of the customer's first order. I do, however, not...

I need to do an audit of 5% of each of my coworkers complaint files. I pulled the data so that Column A contains the complaint file number, and Column B contains the complaint owner. There are about 7 different owners, but every complaint file number is different. I need to pull out a random...

Hello, I hope you can all bare with me as I do not know the proper statistical terms. Goal: I have 30% of my data (both numerical and text). How can I use statistics (probability) to estimate the remaining data? Info: The table below is a simple example of my real data set. Instead of 9...

I'm interested in recreating this table which shows the percentage cut off (or threshold) to earn shares (based on the size of the share pool) based off of volume of sales. The left side of the chart shows the number of shares available to earn. The top row shows the number of shares won. There...

I have following data: A -> 100 150 123 145 167 200 250 300 270 B-> 290 300 280 276 234 234 288 345 399 How can I perform stationarity,cointegration,Granger's test in Excel?

Here is my problem. I have a excel table with a list of items and their chemical components, commitment quality as shown below. <code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera...

Hi Everybody, I'm trying to figure out the percentage chance my team has of making the playoffs in my league this week. I will make the playoffs if one of the following 3 scenarios happens: I win (35% chance) Team A wins (49% chance) Team B loses (42% chance) The percentages I listed above...

Hi, I am trying to write a formula (without Macros, queries, or VBA) to create all the combinations from a list, given certain conditions. I have several plants running several production lines, and if a production line breaks it has a cost as described below: <tbody> Factory Failure of the...

Hello- Newbie here. I am generating data from a small water supply meter every minute and want to get statistics from the data. There are 1440 lines every day and I would like to get a summary report for a month. Ideally I would like Daily statistics. Like Min, Max and Average for each day...

Hello, Im trying to find the ability/process to draw a curve and then obtain tabular forms of the probability distribution of that curve for X = 1 to 60 (1 month to 5 years). Once i have those 60 probability distributions i would apply a total revenue figure over that distribution to timephase...