Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Excel is a commercial spreadsheet program created by Microsoft.

0
votes
4answers
43 views

How to: Analysing 5-Point Likert Scale with ANOVA

I am very confused since I could not find an understandable answer for it: I must analyse my Likert Scale data with ANOVA to get the significance (using the ANOVA is the requirement...). I have to ...
0
votes
0answers
7 views

Log scale for Y axis in scatter3D (Car) or any 3D plot packages in R something similar to that generated in excel?

am trying to set up the Y axis to be in Log2 or Log10 scale in scattter3D, but I have not been able to do it. Is there any way to plot Log scale for the Y axis keeping the original values as done in ...
0
votes
0answers
7 views

Spreadsheet segmentation

I work on an spreadsheet segmentation/ml-based-parsing project. Input spreadsheets vary in shape and formatting to some extend. Goal is to transform any given spreadsheet into normalized database ...
0
votes
0answers
14 views

Lognormal model assistance

I'm a product researcher and I'm working on a model of task completion times for a product. Since the task completion times will all be positive, I have LOG10 transformed them in Excel. I've then ...
0
votes
0answers
20 views

Cross tab with missing values

I have a following kind of problem. I have several countries. For every country I know the cumulative value of the variable of interest after four periods. I also know the cross-country sum for every ...
2
votes
2answers
33 views

How would you go about modelling a sport with a fixed maximum score line (e.g. volleyball or tennis?)

In short, I don't have a great maths background but have always mucked about with modelling sports and making predictions (as I enjoy it). I have always used the Hal Stern "The Probability of Winning ...
0
votes
0answers
14 views

Determine relative and absolute concentration in Excel

I have 3 data sets in Excel about number of stores, amount of gross revenues of some retailers from the past 8 years. I need to determine relative and absolute concentration of data. I created a ...
0
votes
0answers
20 views

Finding Linear relationships in multiple output per input dataset

I have a dataset with many outputs for a given input. In the data there are several linear relationships that are easy to see when the data is plotted. The linear relationships are all of interest to ...
0
votes
0answers
9 views

Ranking based on number & production of referrals

I have a list of approximately 250 referrers that I need a better ranking system for. I have tried ranking strictly by productivity of referrals however that often results in a ‘one off’ doctor being ...
0
votes
0answers
20 views

How to calculate prediction intervals for p values using just the obtained p value (Cumming, 2008)

I've been reading over Cumming (2008) on replication and p intervals. I don't appear to be able to replicate calculation of his p interval for p obtained = .05 following formula B3. I'd very much ...
0
votes
0answers
33 views

Help with forecasting sales

I am trying to forecast out Sales for an individual brand within a retailer. I have all Nielsen Facts (distribution points, total retailer sales, % of shoppers that purchase that brand etc). I was ...
0
votes
1answer
37 views

How does Excel interpolate / imputate missing values in time-series when fitting a line to a plot?

I have a scatter plot in Excel (upper part of the screenshot) of time-series data. In-between the values that I plot (to the left), are some missings. I fit a (linear) line to those values and display ...
0
votes
0answers
29 views

What is this type of semantic differential/Likert scale visualization called and (how) could I reproduce it in Excel?

Source: Nusrat, Sabrina, Md Jawaherul Alam, and Stephen Kobourov. 2018. “Evaluating Cartogram Effectiveness.” IEEE Transactions on Visualization and Computer Graphics 24(2): 1105–18. https://journals-...
0
votes
0answers
5 views

Weighted Standard Deviation in Excel [duplicate]

I have a dataset in excel that looks like this: ...
1
vote
1answer
222 views

Different regression coefficients in R and Excel

Asking a separate question because whilst this has been answered for polynomial regression the solution doesn't work for me. I'm performing a simple linear regression. Both R and Excel give the same ...
0
votes
1answer
25 views

Monte Carlo simulation--Have I applied Bernoulli distribution properly? [closed]

I am trying to run a monte carlo simulation and I just wanted to make sure that I set it up properly. A salesman visits 100 different homes. Someone answers the door 80% of the time. Of that ...
1
vote
0answers
32 views

Find correlation between names and score

I'm new to data mining and hope you can help me with my task :) First some details about my (input data) I've got an excel table with the following structure: ...
2
votes
1answer
18 views

Assessing pre-post survey data with change scores?

I have about 50 pre & post-surveys for an intervention. I am limited to using excel and was told to only calculate the change scores. For example: ...
0
votes
0answers
356 views

Standard Deviation of Discrete Random Variables in Excel?

I am looking for the Standard Deviation of the Discrete Random variable. I understand how to calculate it by hand but when I use the excel STDDEV function, I am getting a different answer. Is there a ...
0
votes
1answer
40 views

read.csv() columns NULL [closed]

This is a very simple question I hope, but just can't seem to solve myself. I'm trying to read a .csv file of integers into R using read.csv(), however for analysis reasons I need to convert all the ...
0
votes
1answer
26 views

Terminology Question (ANOVA/t-test) - With and Without Replication?

Coming from a Psychology background, I have always been taught statistics terms as "within subjects" and "between subjects". Now using excel I see they are using the terms Anova - 2 Factor With ...
0
votes
1answer
34 views

Calculating regression weights from a covariance matrix [duplicate]

My starting point is a covariance matrix (Not raw data) and I want to calculate the regression weights. I may have as many as 6-8 independent variables and 1 dependent variable so looking for a ...
0
votes
0answers
29 views

For a histogram, is there any standard rule about how large the min and max bin should be (underflow bin and overflow bin)?

Working with several large datasets in excel, about N=900. I would like to divide the data into a number of categories corresponding to low, med, high etc. for this biological variable. Histograms ...
1
vote
0answers
14 views

How to represent local significant differences between curves

I want to compare some curves to a 'normality corridor', and I would like to show in what regions (x values) the difference is significant.Take the example below, where I want to compare the dashed ...
0
votes
1answer
38 views

ANOVA & Sums of Squares in Excel and R

In this simple dataset, I have bird populations from three watersheds. I am completing an ANOVA by hand and in R and comparing the outputs. ...
-1
votes
1answer
48 views

A proper function for nonlinear regression with 3 predictors

There are three independent variables in my experimental work, namely flow rate (0.5 ≤ Q ≤ 9 where ΔQ = 0.5), particle size (a = {6, 10, 15}), and a geometric parameter (AR = {AR1, AR2, AR3, AR4}). ...
0
votes
1answer
69 views

How to calculate statistical significance of a difference between two groups?

I have two groups A and B. Each group involves some number of users. For example, let's imagine that the group A has 2000 unique users on Monday, while the group B has 2002 users on the same day. For ...
0
votes
0answers
22 views

Probabilities for a game of chance similar to card game War

For homework, the kid has developed a game of chance but we need to define the probabilities associated with this. It's a simple game. Two players, each has a standard deck of playing cards. Turns go ...
1
vote
0answers
14 views

Basic way to find out relationships and correlations / mediators

Currently I am looking for a very basic way to analyze relationships in a data set which contains nominal and ordinal data. Mainly I want to investigate, whether two groups, defined by a dichotomous ...
0
votes
0answers
34 views

Can binary logistic regression be performed without a reference/baseline category?

I have different independent categorical variables with more than two categories, dependent variable is binomial. How do I compare the effect of these independent variables w.r.t an absolute reference ...
0
votes
0answers
289 views

Exponential double decay curve fitting in Excel

Please refer the attached image. I tried to fit the curve with an double decay exponential function in excel using GRG nonlinear solving method. Every time I run the solver, I get the result stating ...
0
votes
1answer
754 views

Excel Regression - Training and Test Data

I am curious about the Excel regression function and evaluation of training and test data. Unlike using a program like R or Python where you state the values for your test and training data, Excel ...
0
votes
1answer
52 views

What is a good model to forecast a single variable?

Let's say I have the values of a variable x for a time period of 15 years. What is a good statistical model to find the values of this variable for the next 10 years? How good is excel's forecast ...
80
votes
8answers
11k views

Line of best fit does not look like a good fit. Why?

Have a look at this Excel graph: The 'common sense' line-of-best-fit would appear be an almost vertical line straight through the center of the points (edited by hand in red). However the linear ...
1
vote
1answer
26 views

Make value ranges to guess

Hi I have excel sheet with following like data of shoppers and money they used: ...
0
votes
2answers
427 views

How can I plot an ROC curve? [closed]

Given this simple data: How can I plot an ROC curve in Microsoft Excel? Step by step instructions would be very helpful. I know my TPR is ~87% and my FPR is ~13%. How do I know where to set the ...
1
vote
1answer
46 views

Office Desk Rota Assignment problem

This is not a home work and the question is not related to studies (I am not a student). I have to do the weekly desk rota at the office and thought this forum might help with suggestions. My problem ...
1
vote
0answers
32 views

Which statistical test should I use to compare land use type and species abundance?

I have abundance data for a species of bird and data on land use type in the areas where the bird data was collected. I want to test whether land use type affects bird abundance but I don't know what ...
3
votes
1answer
33 views

Analysis of a dataset including dichotomial, ordinal and % data

I'm working on a dataset which is giving me trouble. I have 200 samples (Sample 1, Sample 2...). An example dataset (limited to 15 samples) is here. My dataset is structured with the following ...
0
votes
1answer
116 views

Statistic problem to be resolved on Excel (or VBA) [closed]

I have a stat problem and I am not sure it can be resolved; I am not good in statistic but maybe someone can help me: I need to create two numbers: $v_1$ and $v_2$ with Excel or VBA. I want both ...
0
votes
0answers
28 views

Putting a sample into a bucket depending on its probability

I'm currently working on a project that requires some statistical analysis. Last time I had stat/prob lessons was fifteen years ago, so it took some racking of the brain :) I think I have found the ...
0
votes
1answer
52 views

Sample Size Estimation for Two Sample T-Test (Excel)

I'm trying to work out how to calculate the necessary sample size for a two sample t-test using excel and need some help. I don't think I am able to upload an excel attachment, so I will write out ...
0
votes
0answers
91 views

Swapping Axis for Dependent and Independent Variable

I'm working on a project where I'm trying to present some hydrology data, and I'm trying to create 26 scatterplot charts with regression, all of water velocity vs depth. However, we want to be able to ...
0
votes
1answer
31 views

What type of distribution to use?

This is my first post here. I am making a financial model in excel of the feasibility of a project. Herefore I need to make some assumptions. One of those assumptions would be the fuel price and how ...
2
votes
1answer
515 views

Forecasting Monthly Timeseries Data in Excel

I am trying to create a forecast using a monthly timeseries data set of marketing expenses for a fictional company. The data looks something like this: Using linear regression to forecast future ...
2
votes
3answers
60 views

How to isolate price effect in time series?

Here is what I have: Excel Yearly energy prices by state from 2002 (generally increasing, generally peaked a couple of years ago) Yearly energy consumption by state by industry from 2008 (about 700 ...
0
votes
0answers
32 views

Examining Trends in Neighborhood Data using Excel

I am tasked with a project that asks me to examine trends by neighborhood of various determinants of health (crime rate, poverty rate, unemployment rate, housing) and different health outcomes (infant ...
0
votes
0answers
37 views

How to take samples from a weighted distribution in Excel?

[not sure this is the correct StackExchange Forum - please feel free to move elsewhere!] I am building an Excel model, where I have 1000 patients with some chronic disease, grouped by how seriously ...
0
votes
0answers
17 views

How is this statistical index called?

I need to calculate an index that is to be derived like this: If we have some data: 850 700 500 480 300 100 50, we first sort it from the large to small: ...
0
votes
1answer
37 views

Calculating t-value for regression coefficients

I am estimating a nonlinear model as follows: $$Y=B_0+B_1X_1+B_2X_2+B_3aX_3^{1-b}+B_4$$ I have estimated $B_0$, $B_1$, $B_2$, $B_3$, $B_4$, $a$, and $b$ using least squares in Excel (minimizing SSR ...