excel

Hi All - I have built a very simple model. I have developed a regression model in MS EXCEL to predict if the FTSE 100 is fairly, under, or overvalued. Forecasting EPS: Dependent variable - Trailing 12 months EPS (£) Independent Variables - Brent Crude Price ($), Bloomberg Industrials Metal...

Hello, I am not particularly well versed in statistics but I am doing some research and encountered something I didn't understand and was hoping someone here could help. For my research, we need to find the pump speed with the most consistency when filling a vial to 50ml. I am not sure if I...

Hello friends. I am fairly new to the world of statistics. After trying and failing to do R, I have just decided to use Excel for my data. A bit of background: I have 148 sampling sites, each with several species associated with them. I am looking to find the correlation between land use and...

I'm a student of data analytics. I've the following raw data https://1drv.ms/x/s!Amd7BXzYs7AVhAqQGtBZLHzQ1xZ6 The main goal as for finished example :https://1drv.ms/x/s!Amd7BXzYs7AVhAsWa0e5yvqPhuRf?e=DyEmyo Base on provided information we need to determine project revenue and cost. Revenue...

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

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

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

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

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

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