excel

I have a dataset showing the yearly stock returns for two investment styles (growth and value investing) as well as a column showing the difference between the returns for each year. I have attached a picture below. I want to do a test to see if the difference is significant for each individual...

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:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Sorry I want this deleted

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