# Tagged Questions

Excel is a commercial spreadsheet program created by Microsoft.

3 views

### Splitting a dataset into dynamic groups

I am looking to split a dataset into multiple groups based on two criteria: - the smallest and largest number in the group must be within a range of 30 - the grouping must be optimised such that the ...
21 views

### Are the Standard Errors of parameters from regression of log data in Excel correct?

I was putzing around with Excel and the LOGEST function. This fits your data to $y=ab^x$. It does this by linearizing the data, and doing a least-squares fit to $\log(y) = \log(a) + \log(b) x.$ It ...
55 views

### When using a limited data set, how can I use excel to forecast future values?

To preface, I am a statistics novice, but I am faced with a problem that I cannot seem to be able to satisfactorily resolve. The problem is as follows: I am working to forecast future sales for one ...
4 views

### How to make it so only the labels show up as points on a scatter plot in excel [migrated]

So I am trying to plot countries on a graph in excel using two letter codes, but the points keep getting in the way and cluttering the graph! Is there any way to remove them and only keep the labels? ...
59 views

### Calculate matrix exponential without dedicated software package [closed]

Is it possible to determine the exponential of a square (non-diagonalizable) matrix without a dedicated package: for example, through a series of equations within a spreadsheet?
54 views

### Inverse of Normal Loss function in Excel [closed]

I am looking for a way in Excel to obtain k by inverting the standard-normal loss function G(k). The CDF and loss function for a a variable z that is normally distributed are defined as The formula ...
12 views

### How to visualize a point series within a grouped bar chart in Excel? [migrated]

I have created a grouped bar chart within Excel, that shows the mean wage of men in different countries (y-axis), represented by different occupation groups (categories). Now I want to enhance the ...
9 views

### Dynamic Yearly / Monthly Charts in Excel [migrated]

I would like to create a dynamic line chart in Excel. The objective is to view a specific timeline inputted by the user. For example, if I want to view the first 12 months of data, the chart will show ...
41 views

### What statistical test to use - comparing models?

Say, I have created 3 models that evaluates the amount of harmful pollution. It uses a variety of factors (location, time of year, etc.) to determine this. I have a bunch of data for 10+ Cities from ...
35 views

### Expected Value clarifications using R/Excel

So it has been a little while since I've taken my last statistics course, and I wanted to double check that I am not making any kind of grave errors in my expected value calculations. Quick bit of ...
24 views

### Sample Size Formula for Wilson Score, Clopper Pearson, and Jeffrey's

I am interested in finding the sample size formulas for proportions using the Wilson Score, Clopper Pearson, and Jeffrey's methods to compare with the Wald method. Also if anyone has code to replicate ...
27 views

### Excel Realstats MANN_EXACT function

I'm trying to compute some mann-whitney tests on my datas, and I use the really handy "Realstats". As you can see on this link, there are several functions available. As a noob in stats, I used the ...
15 views

### exporting from R objects of class “gts” “hts” [closed]

I am trying to save my forecast of class "gts" "hts" from R into excel but I get an error in R - "cannot coerce class "c("gts", "hts")" to a data.frame". Thank you, Despina
24 views

### Confidence Interval for Regression Line (simple linear regression)

So I've constructed a confidence interval for my regression line. However, because I have 2500 data points it is a very, very narrow interval (I can barely see it next to the regression line when I ...
30 views

### How to determine if a set of data is Student-t distributed

So I know how to use goodness of fit tests generally. For example if I wanted to check whether my data came from a Poisson distribution I would first estimate the parameter using MLE (so just the ...
70 views

### How can I have the sigma of a normal distribution when I have f(μ)?

How can I find the standard deviation $\sigma$ of a normal distribution satisfying the following criteria? \begin{align} μ &= 12 \\ f(μ) &= 0.5 \end{align} Basically, I have the mean $μ$ and ...
18 views

### Service Level Caluclation with Double Truncated Normal Distribution

The purpose of this exercise is to determine how the number of employees working affects the service level of their job within the organization they are a part of. EX. A call center gets 100 calls a ...
24 views

### Coefficient of correlation from averaged and not averaged data

I want to understand why I get two different results for $r^2$ from the data I post. I use the linest function in Excel. One more noob question about weighted ...
15 views

### Displaying two sets of data with unequal number of data points in Excel

I have two sets of data to display in a single chart using Excel 2010. First set is the exchange rates over time for GBP against the USD and EUR - this has daily plots so I have about 7300 ...
20 views

### How to calculate the weighted standard deviation [duplicate]

I have found many equations which claim to be for weighted standard deviation, yet all of these differ very slightly, and I am confused as to which is the correct one. I have some data in Excel, and ...
51 views

### Multiple Correspondence Analysis [closed]

I have a problem I can’t find a way to solve, even though I think it’s possible. I have an Excel file with some data related to patients. The patients have a certain diagnosis [coded as a number (1, ...
30 views

### Ran a logistic regression and fit my data to the predicted model but the predicted model is not overlapping the observed data

EXPERIMENT: Heaviness judgments of a variable weight to a standard weight (2000g). Independent variable/covariate: Weight (9 levels: 1920g, 1940g, 1960g, ... , 2060g, 2080g) Dependent variable: ...
47 views

### Translate R lm poly output to Excel equation?

I have the results of a lm model and its a so-so fit but now I have to dump it into an Excel file to do predictions. Most of it I get but the POLY factors I don't understand and where there is data it ...
46 views

### Calculating relative growth rate in R or excel [closed]

I'm currently trying to work out the relative growth rate of individuals using the equation RGR = (lnW2-lnW1)/(t2-t1) so log of weight at time 2 minus log weight at time 1 divided by time 2-time 1. ...
40 views

### What program to use for data presentation? [closed]

I need to plot few graphs for my dissertation, I would use GraphPad Prism however my 30 trial has expired and I cannot afford to buy it. R- sounds good but it is far too complicated and I, ...
170 views

### Statistical analysis of relational database: is it possible and how?

I have been struggling with flat file databases and corresponding statistical packages for almost 20 years now (from Excel to SPSS, then Stata, and currently R). However, I have always had to convert ...
47 views

### What does subscript i mean in statistics in this context (table with values included)?

This has been driving me nuts for hours. I cannot find information anywhere on the internet on what the formulas in the upper-right two cells mean. The i subscript is throwing me off.
12 views

### Calculating trends and averages on skewed data?

I'm running analysis on an Audit that has been distributed over the course of a year. There are currently about 40 or so different audits. Each audit contains 90 questions. When the audit was first ...
15 views

### Multiple regression: forcing y-intercept=0 improves R^2, is this correct/possible? [duplicate]

I have been running multiple regressions in Excel successfully (using the Data Analysis Toolpak) but when I run the same regressions and force the y-intercept through 0, the R^2 values are very ...
22 views

### analysing 7 point likert scale data

I do not have any background in statistics. however, I am conducting research for my thesis. I have gathered 32 data (initially) and I need to present primary data to my professor, I am using Excel to ...
38 views

### Paper on Excel problem

This might be a rather esoteric question, but .... I once encountered a paper / technical report that showed that Excel (up to some version) was using a numerically non-stable method to compute ...
68 views

### How can I calculate and display deviation from a linear trendline?

I am working in excel, and I have plotted some data in a scatter plot. I added a linear trendline, and I want to calculate the deviation of each data point from the trendline. I am plotting allometric ...
20 views

### Smaller p-values on a selective multiple regression analysis [duplicate]

When I run a multiple regression analysis in Excel on 20 independent variables and 1 dependent variable (in two goes), I obtain in the summary a set of p-values. When I select the (six) ones that are ...
51 views

### How to calculate Standard error of Normal Distribution with given Confidence Intervale

I have one basic question in preforming the forecast of fertility rate. I assumed if the fertility rate (is normally distributed) is equal to 3.0, there is an 80 per cent chance that fertility would ...
56 views

### What kind of distribution is my QQ-plot and histogram?

I am pretty in new in distribution issues and I am trying to figure out what kind of distribution I have. I have a historical data with more than 300 observations. I will calculate Value-at-Risk (VaR)...
114 views

### How can I transfer an ARMAX model in Excel in order to forecast future values?

I am currently trying to set up an Excel based tool, that alows to predict future values based on an ARMAX model, previously set up in SPSS. The Excel tool contains the coeffienients, calculated by ...
62 views

### Implementation of Naive Bayes Classifier in Excel?

I need help for implementation of Naive Bayes algorithm purely in Microsoft excel. I have 5 independent variable. I have already implemented in R but I would like to know is there any way to implement ...
95 views

### Statistical Analysis: Fisher exact test or chi-square test?

I am trying to do statistical analysis for a user survey. The total number of survey to be analysed is 59. The variables in the survey can be defined as a categorical variable. Some of the ...
14 views

### Ignore data where the minutes modulo five are not equal to zero

I've some data that I'll analyse. Every five minutes there was taken the power (P) of solar panels over five years. I've calculate the kilo watt hour of that moment by this formule: P[Wh] = P[W] ⋅ ...
42 views

### Calculating actual quantile from poorly defined lognormal distributions

I have a dataset in which the uncertainties in various parameters are modelled with a lognormal distribution. After the experiment I get a single number result. As part of a lookback to understand how ...
112 views

### R forecast ets initial level and trend

I am trying to understand how the ets function of R in the forecast package computes initial level $l_0$, and initial trend $b_0$. I was under the impression that they are set to the intercept and ...
482 views

### How to inverse loss function L(z) to normal standard distribution (z) [closed]

z is the standard normal distribution F(z) is the probability normal distribution L(z) is the standard loss function I can find these values using below code ...
36 views

### Predictive model building across seasons (time, year)

I'm using Excel - and yes that's very basic but have to start there. My hypothesis is that you can predict amount of people getting the flu by looking at social data. I have two datasets: - Social ...
64 views

### What test should I use to explain a natural phenomenon in three variables?

I have hundreds of sample points where I have data of three variables ranging from 0.0 to 1.0. I would like to use some statistical test to find a function that could predict a phenomenon. I also have ...
345 views

### Alternative visualizations to 3D bar chart

I have a dataset that consists of a numerical variable (height, y-axis). Each data point is replicated for an individual (1,2,3) in each treatment (A,B,C,D). Here is a terrible figure that I am ...
17 views

### Multiple regressions with same dependent variables

I was recently working on some problems dealing with regression, anova, and the like and in these problems there were 10 regression tables. 5 of which each had different dependent variables. 5 which ...
77 views

### Variables Importance to Predicted Value

I'm working on a model to understand the predictors (variables) importance, and whether going forward I should include them in the model which should scale over > 1M rows. Here is a sample of my data:...
34 views

### Standardized coefficients to zero mean

I was reading in the literature that in order to compare linear regression results with independent variables & categorical (variables), it is recommended to standardize the coefficients to a zero ...