# excel

1. ### Two-sided test of equality for column proportions

Hello! I have a table of data that I have to show statistical significance for. The data compares the number of minority vs. non-minority persons in a program who were employed vs. unemployed during quarter 2 last year. I have to show that the differences between minority vs. non-minority...
2. ### Different coefficients from regression and trendline equation

I have two variables 'x' and 'y'. I took the natural log of the 'y' variable and then plotted the ln(y) vs x on a scatterplot in excel. I added a logarithmic trendline which seems to fit perfectly. The line equation is y = 1.1282*ln(x) + 12.183 with an R-Squared of 89%. However when I run the...
3. ### A statistical test to determine strength of correlation (or probability of certain outputs) over three timepoints

Hello, New to this forum and bit of a stats newbie so forgive me for any if my question is too vague or I say anything incorrect. My dataset is ELISA outputs for 10 individuals over three timepoints with sample size. I want to see if the individuals remain in the same order over the 3...
4. ### Which T-Test tails/types do I use in Excel?

Hi everyone, I apologise in advance in if I have posted in the wrong thread. I am trying to perform a t test here where I am using the AssessMark against the SuprtScore, QualScore, SatisfScore and SysBen columns. As I am using excel to perform the computation, I am not so sure if I am doing it...
5. ### Finding P-Values For a Null Hypothesis with Neutral Trend

Please help me. I am so lost. I have data that is days above a certain temperatures every year from 1948-2019. So basically something like: 1948 36 1949 31 1950 36 1951 34 1952 36 1953 35 and so on. To find the trend I already did a least-squares linear regression and go that done. Now I...
6. ### Which statistical test do I need to use?

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...
7. ### 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:
8. ### 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...
9. ### 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...
10. ### 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...
11. ### 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...
12. ### 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...
13. ### 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...
14. ### 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...
15. ### 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)...
16. ### 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...
17. ### 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...
18. ### 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...
19. ### 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...
20. ### 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...