excel

1. Doing Probability through Excel

Hi everyone! This is my first post here so I hope I am doing it correctly. So I have been given a piece of work from my university in regards to using Excel to conduct certain probability finding questions. I will write the questions below and show you what I have done so far in hopes for...
2. Error: (2067) The Excel file is password protected. Unable to open the file.

Hello everybody, For my study I have to use SPSS. I used an online survey tool where I had the opportunity to download the result in an Excel file. Thereafter I tried to open the file in SPSS. However, it keeps showing the error 'Error: (2067) The Excel file is password protected. Unable to...
3. 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...
4. 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...
5. 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...
6. 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...
7. Monte Carlo Simulation?

Sorry I want this deleted
8. 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...
9. 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!)...
10. 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...
11. 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...
12. [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...
14. 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...
15. 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...
16. 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...
17. 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...
18. 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...
19. 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...
20. 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)...