excel

1. Chi-Square Triangle Beer Test with weird answers...

I am trying to help develop a test for deciding if two different beer recipes taste statistically different under a blind triangle test. I created an equation in Excel to calculate the CHI-Square value and it works most of the time (which is worrying because it should work all of the time.) Upon...
2. Hypothesis Testing - Obtaining T-Stats and Critical T-Values

Dear all, I have been given the following question I don't really understand how to interpret this question. Commonly, hypothesis questions refer to one sampled variable with a given criterion. But this question just states that I must test the null hypothesis that one variable is not...
3. Excel Simulation (Monte Carlo) help

Hi all, I've been racking my non-statistical brain on my Excel simulation (monte carlo sim predicts profit). I have created the model and as I review the outputs, I'm not confident that it's correct. With that said, is there anyone who could review it and let me know if you see any obvious...
4. Excel Formating Help

Hello! How can i format a table in Excel so, if one of the cells in the table is a text, it is counted as a certain value in another SUM cell For example : A B C D E F 1 8 *text* 6 9 3 SUM1 2 *text* 3 4 *text* 2 SUM2...
5. Monte Carlo Simulation?

Sorry I want this deleted
6. What formula would I use?

Im doing a project for my experimental psychology class . For my project I had to carry out an experiment start to finish. The purpose of my experiment was to see which sex is more accurate at detecting transgenders. So I had 10 pictures of non-transgenders and 10 pictures of transgenders. On...
7. Syntax for Recoding Dates

I have a range of dates from ~1950 to the present that are in the 5 digit Excel/Microsoft date code. I'd like to create date ranges. I'm looking for something like recode date into year (42005 thru 42369) = 2015 (the above syntax might be off by a bit, but you get the picture!)...
8. Calculating Population-weighted Atkinson index in Excel

For my dissertation, I am calculating inequality on a worldwide level, between countries. In my calculations, I would like to give each country a different weight according to the share of population they have in the total world population. So far, I have had no troubles in finding...
9. Standardizing monthly sales figures in excel

Hi everyone, this is my first post. In excel, I have approximately 723 rows of sales figures, broken down by month. I have an average monthly purchase (in Dec. 2014) of $24,500.47 and standard deviation of$76,232.24. The problem is, many of the rows have a \$0 purchase (that member didnt...
10. [Excel] How to keep track of metrics

I have a data table with 3 Columns that I want to be able to measure the performance for. Ex. Number| Stage | Date/time 111111 | First Stage | 06/25/2015 10:00 AM 111111 | Second Stage | 06/25/2015 11:00 AM 111111 | First Stage | 06/26/2015 09:00 AM 111111 |...

I first want to say that this is my first post so sorry if I put it in the wrong topic, second English isn't my mother tongue so sorry as well for bad grammar, word choice or sentence structure. Currently I'm doing a research about upcoming students and if they make a more conscious / aware...
12. Export Raw data with Code to SPSS

Hi there, I have recently download every software package you can imagine to try and find one that codes the raw data and then exports it to SPSS, with no avail. I have tried QDA MinerLite, MaxQDA, & Atlas.ti , all code perfectly and once I get the exact table I want to export to SPSS, I...
13. Using MLE to find the right distribution

Hi, I know that MLE can be used to find the best fitting parameter assuming a that the distribution is known, but is there a way (using Excel or SAS) to find what distribution best fits the data (together with the best parameter of the distribution), in other words, the distribution is not...
14. How to read Excel into R and execute hurst(x)?

I never used R before and so need help on a seemingly trivial issue: I have an excel file "data.xlsx" and want to run the function hurst(x) on it: http://www.inside-r.org/packages/cran/pracma/docs/hurst I have Rstudio. How can I import "x=data.xlsx", and run the function hurst(x)? I...
15. Binomial Test in Excel

What is the probability of getting AT LEAST 79 out of 90 correct on a True or False test if you are guessing on every question? I think I need to do a cumulative binomial test for this. But I don't know how to do this in Excel. Would it be =Binomdist(79, 90, .5, FALSE) or would it be...
16. Excel formula for the inverse Pearson IV distribution?

Hello Everyone, What is the excel formula to generate the inverse Pearson IV distribution? I have mean, standard deviation, skew and kurtosis and I plan to generate random outputs given those stats. How do I write the formula? My question is very direct and simple. I've looked everywhere...
17. ANOVA help - comparing growth rates between groups with 3 replicates in each group

Hi I'm really pretty lost, statistics have never been my strong point. I need to test whether my growth rate differences between trees are significant or not. I tried the ANOVA: 2 factor with replication on excel, but keep getting an error so I'm not sure if my data is suitable. SO first off...
18. Create tables /// export tab results directly to excel

I generating a descriptive report for my boss ( that is just frequency tables). I tab everything in stata and the copy as a table and paste it excel. This can be a cumbersome task if i have many variables. Specifically, I have a bunch of scale variables:Are you proficient in: (1 to 4 scale)...
19. Numeric data become String data when transferred from excel to spss?!

So I had some data from excel and I wanted to import it into SPSS to carry out T test. it looks like this on excel. perfectly fine percentage data however when it was imported to spss...it looks like this it became string data and i dont know what happened. all the percentages are gone...
20. P

basic 3 year's observations forecasting - need for tips and feedback

Hello everybody, I need advice about simple forecasting strategies and wondered if anyone here could kindly give me feedback. In each of the four charts shown below we have three results (2011 to 2013) of the number of farmers (above) and school teachers (below) that have enrolled and...