# excel

1. ### How to calculate a cut-off for a scorecard in excel?

0 How to calculate a cut-off for a scorecard in excel? I tried to have a WoE(weith of evidence) and IV(information value). this is my data:
2. ### Difficulty formulating Linear Programming Model Equation

I'm dealing with the following question and am not able to formulate a linear programming model for it: - Suppose that the minimum number of security staff required at different hours are at the ith hour (i=1,2,…,24) are outlined as follows (see picture) Each staff must work in 6 consecutive...
3. ### SPSS Discriminant Analysis in a Type

I did a study where I used 4 variables in a cluster analysis and came up with 5 natural groupings of the respondents. Now my client wants me to create an Excel typing tool for future respondents where they will put in the answers to the 4 variables (3 categorical, 1 continuous) and the tool...
4. ### Tracking trends in count data - excel

I seem to have forgotten how to something I'm sure I used to know how to do... I'm looking at count date and I want to be able to plot when each 'thing' (my example is colour, but not in real life) by date and time - so that I can visually see when each 'thing' happens most. Normally I'd just...
5. ### Qualitative Analysis

Hi everyone! I am working on a study from a survey done in Survey Monkey that has 5 questions that were open answer with approximately 500 respondents who provided comments to those answers. I now have to look at each question and review the qualitative data from those questions and break them...
6. ### RStudio CSV Import of incorrectly formatted data

Hi everyone, new to the site, hope I'm posting in the right place. Just started using R after a recommendation from my uni tutor in order to process the data from my dissertation experiment. I'm most used to Matlab and the transition has seemed pretty easy so far. I've just finished my...
7. ### Excel 95 % confidence interval

Hello everybody, I am learning about data science at the moment. I want to calculate the 95% confidence interval for the amount of Long-Term Debt that I could expect to have with Long Term Assets of \$50,000,000. I calculated a regression analysis for the impact of long-term assets on long-term...
8. ### Merge individual clustered bar charts as a single chart?

I've been trying to create a specific bar chart by using Statistica 12.5 and Excel 2016, no luck however. I want to place my ecological parameters on the X-axis and numerical values (0 to 12) on the Y-axis. Additionally, at the same time I would like each parameter on the X-axis to have its...
9. ### what type of ANOVA should I use?

population =30 Breaking it down Number of male participants =20 Number of Female Participants = 10 Number of Working Participants(W) = 8 Number of Non-Working participants(nW) = 22 I surveyed the students and here are given the raw datas (multiple choice for question number one)...
10. ### Export output to excel

Hello, I have a problem with exporting spss output to excel. I want to export data from binominal tests and logistic regression to excel in a certain format. For example the output: Category N Observed Prop. Test Prop. Exact Sig. (2-tailed) Gender Female 8 0,75 0,50...
11. ### Help with figuring out confidence interval level

Hello. My group was conducting a statistics study and we had all our data in an Excel file. We held a pretest (asked survey to nonmembers of the population but had the same characteristics). The results that we got from there was what helped us determine the needed sample size from the actual...
12. ### 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...
13. ### 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...
14. ### 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...
15. ### 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...
16. ### 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...
17. ### 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...
18. ### Monte Carlo Simulation?

Sorry I want this deleted
19. ### 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...
20. ### 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!)...