statistics

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

I have a large table of data that spans 24 columns and 18K of rows. I want to have an output that scans the mass data and returns 24 columns of only 365 rows (1 year or maybe 2). That will further be processed into a few rows calculating Std Dev, Median, Mean, Percentile, etc. In terms of...

Hello! I have conducted a survey and now I am required to show how the answers vary depending on two variables: Q9 and Q10. I can easily do a two way cross tabulation, but how do I analyse each question against both variables? To give more background: Questions 1-2 relate to employee...

Hi I'm wishing to use spreadsheet formula within a macro to get a desired result. I understand the concept of using a formula with a macro but having it work a little for complex i'm totally stuck! My spreadsheet looks as follows (each individual has a tab like this one) A B C...

Problem: X is a normally distributed variable with a mean=30 and standard deviation=4. Find a) P(x < 40) b) P(x > 21 ) c) P(30 < x < 35) How do i input this in excel. I'm actually having problems on how to put "<" and ">".

I have calculated a Polynomial Trend Line with an Order of 5. The R2 value = 0.9994 However I need some help to calculate the Y value based on the following formula y = 1E-07x5 - 3E-05x4 + 0.0022x3 - 0.0182x2 + 4.9966x + 2.2429 Sorry but Im unable to show powers so I will try and explain...

Hi, I've used trend lines to find the mean and average but for some reason I have not been able to set an upper and lower limit. without introducing a new column. Please do let me know if there's a way around this. Thanks

Hello, Pls don't bash me but I have reached my limits with excel I am looking for some help with some statistical help. I have 3 data columns Date of Measure/ Time of Measure/ Voltage Measurements. I have 31 days of data with samples every 2 min. The time is shown in 24hrs format. Is that a...

Hi all, I am using an MSExcel template (MAKESENS 1.0, it's free and available online) to calculate the Mann-Kandall test and Sen's slope for a trend analysis of a wind speed time series. So, I have 62 years of data and the template (VBA code) works fine if I don't have zero in the time series...

Hi I need to create a metric which compares Courses run, and the impact of changing the Course duration, or the Maximum number of students allowed on each course.... In some cases the Duration or Max number changes... In other cases both could change.... I just can't think of the most suitable...

Hi All, I have completed multiple charts and statistical analysis years ago in statistics class and I cannot remember how to do a simple analysis of a multiple year, weekly attendance record. I used the linear chart template and plotted the data that way, but I'd like to take it further and add...

Hi, I'm a longtime lurker, but haven't been able to find a post that fits this (seemingly simple) purpose. I have multiple data sets containing two columns (Quantity & Price) which I want to revert back to raw Price data in order to make a statistical distribution curve. Example of Data...

A class I am taking encourages using R for stats but, since I know and use Excel all day, daily, I would prefer to use it - but am not sure if I can do most of the same things. Anyone know? Those who use R love it and advise against using Excel for this. Thanks!

Hi, I've got lots of rows of data in Excel (around 3,500), and multiple variables. 1 of my variables is continuous (company revenues) 1 of my variables is a Yes or No 3 of my variables have a few (3-5) discrete options The output is money (continuous). I'm trying to use Excel 2007 to find the...

Hi, I am using statistics to develop a finacial model on excel. I have created a table that lists returns of a security over a given period of time. I have used formulas to calculate the mean and standard dev of the returns. Right now, I am using the norm.inv function =norm.inv(.05...

All, I've written a macro that does a rudimentary Benford analysis (the first digit comparison only), but after looking at the code I produced, I can't help but think there must be a better way to do it. I'm a beginner coder, at best. I'll paste the code below, and I'd love to hear if anyone...

I am planning to use Excel with Power Pivot for my masters thesis and in order to justify the use of Excel over another Engineering/Statistical software, I would like to refer to the number of users of Excel worldwide and in South Africa ( therefore the solution I develop can be spread easily...

Here is a stumper, at least it has stumped me this far, below in E2 is the formula: =((SUM(B2:B6)/COUNTA(A2:A6))(SUM(A2:A6)/COUNTA(A2:A6)))/((SQRT((1/(COUNTA(A2:A6)-1))*((SUM(D2:D6))(((SUM(B2:B6)-SUM(A2:A6))^2)/COUNTA(B2:B6)))))/(SQRT(COUNTA(B2:B6)))) I can't figure out how to replace the...

I tried searching for similar threads, but couldn't quite find what I was looking for. I am well aware of Excel's capabilities when it comes to calculating standard deviation. However, I would like to code it myself in VBA. I can't get the below code to work and I have no idea why. Any help...

I'm sorry, but I know nothing about Excel. I know very little about anything when it comes to computers, but I'm here to ask for your kind help. Google just told me that Excel can compute info into statistics, and statistics is what I need. Me and my friends have ran a test on how colors affect...