excel

  1. L

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

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

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

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

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

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

    Monte Carlo Simulation?

    Sorry I want this deleted
  8. T

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

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

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

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

    [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 |...
  13. M

    Please help analysis between Nominal and interval Value in Excel

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

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

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

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

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

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

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

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