Excel is a commercial spreadsheet program created by Microsoft.

learn more… | top users | synonyms

0
votes
0answers
7 views

how to display data as a banded/area chart when data is minus? [on hold]

I have a predicted dataset to display as a line with a upper and lower 95% confidence which I want to use as an area display i.e. as error bands. I initially followed this tutorial ...
0
votes
0answers
21 views

Tools to reverse-engineer an Excel spreadsheet [closed]

I have at various times been asked to improve some predictive model whose only implementation and documentation is an Excel spreadsheet. What I want instead is a concise set of equations describing ...
0
votes
0answers
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 ...
0
votes
2answers
32 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 ...
0
votes
0answers
26 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 ...
1
vote
1answer
32 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 ...
0
votes
0answers
29 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 ...
1
vote
1answer
45 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 ...
0
votes
0answers
12 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] ⋅ ...
2
votes
1answer
36 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 ...
0
votes
1answer
45 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 ...
1
vote
0answers
78 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 ...
0
votes
0answers
30 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 ...
0
votes
1answer
55 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 ...
2
votes
3answers
143 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 ...
0
votes
0answers
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 ...
0
votes
1answer
56 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 ...
2
votes
1answer
23 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 ...
0
votes
0answers
17 views

Validating poissonic (mutation) data using 95% confidence interval

I've been tasked with the following: We want to verify the quality of DNA sequences from a lab without redoing the assembly ourselves. These "query" sequences (say influenza) from the other lab are ...
3
votes
2answers
80 views

What kind of chart can visualize individual points of data on a single axis?

My core problem is trying to visualize the workload of a customer support team throughout the week. Specifically, I want to see what the load looks like hour by hour on each day for each agent ...
0
votes
1answer
16 views

Remove the effect of a variable from output

How do I remove the effect of a variable from the output? Say we have a stock market index, I want to know how the index would look if you take away one of the variables. I will have run a regression ...
0
votes
0answers
7 views

How to apply weights to data to adjust percentages that are based on different population sizes

I have a problem where I'm dealing with population data. I have data on approval for a product. The problem is that we have a lot more data in some zones than others. How can I apply weights to make ...
0
votes
1answer
59 views

What would be a clear way of showing both the homicide count and rate in one single visualization?

I'm learning to use Google Charts API in order to play around with data from UNODOC statistics. I found this excel file providing information about homicide count and rates from countries in the ...
0
votes
0answers
83 views

Neural network prediction using back-propagation

I found pdf tutorial to create an excel based neural network, using the solved add-in. Unfortunately, the formula giving the predicted output is not provided. Is there a recognized way of using the ...
0
votes
2answers
49 views

Excel dates and R? [closed]

First of all I already looked for an answer to my question but all the methods and scripts in other answers are not quite working with mine. Im beginner in R so have me patience please! :( I Have a ...
3
votes
1answer
66 views

Excel Regression: What to do if one of my P values aren't acceptable but can't be removed?

I am doing regression in excel and I have dummy variables for Quarter (seasonal values) P values for Q2 and Q3 are significant but my Q1 P value seems too high. I can't exactly pull out Q1 ... What ...
0
votes
1answer
27 views

Which number should I use for In-between group analysis by using Fisher's exact test?

I have to find out if the baseline demographics have statistically significant difference between two groups. The project is about two groups of students, one intervention group and one control group. ...
5
votes
2answers
264 views

How can $R^2$ have two different values for the same regression (without an intercept) [duplicate]

My question is multifaceted. So I'll start by asking my question and then explain what has caused me to ask this question. How can I calculate the coefficient of determination for a linear ...
0
votes
1answer
41 views

Meaning of Intercept and what the intercept should be with no measurement error?

I'm going into University this year, Engineering to be more specific and I was given an assignment over the summer about regression. (Something I have no knowledge about) Basically, in my questions I ...
0
votes
1answer
13 views

Comparison of two different ratings of ten variables

I am rating the quality of a product across ten dimensions D1 to D10, e.g., durability, price, advertising, etc. Each dimension receives a rating from 1 to 10 (1 = lowest, 10 = highest). I have a main ...
1
vote
0answers
13 views

How can I create a globally adjusted sampling distribution based on the regions of Morocco?

I have a table of population statistics from Burundi with the following: Province -- Population -- Sample Distribution -- Global Sample (Distribution Adjusted) The table continues with each province ...
0
votes
1answer
129 views

Binary and Continuous Correlation

I'm confused about finding correlation in these two cases with using Excel: 1- Correlation of two binary variables : (Male/Female,Interest to Coffee(Yes/NO)) 2- Correlation between one continuous and ...
1
vote
1answer
895 views

How exactly are standardized residuals calculated

I'm working on a model for something and at the moment I prefer working solely in Excel. I've been double checking the results of the linear model in JMP, Minitab, and Statistica, and (more or less) ...
2
votes
1answer
36 views

I have two sets of data, what is the best way to fit one set of data so it most closely matches the other

I have taken two sets of data with two different instruments. We know data set A taken with instrument A is very accurate and precise and that set B, while precise, is not accurate. Thus my data sets ...
0
votes
1answer
30 views

Nonlinear forecasting

I'm working with time series data (which fluctuates constantly) and currently have 27 data points to forecast with. Would anyone be able to recommend a nonlinear forecasting method using formulas to ...
1
vote
1answer
79 views

Use CHIINV or CHISQ.INV to report Chi Square statistic?

I'm looking to report a chi-squared statistic for a chi-squared goodness of fit test using a 2x2 table. ...
1
vote
1answer
73 views

Weighted median of a portfolio

I need to calculate weighted median return for a portfolio (using MATLAB). There is information available online: MATLAB Central/rates&weights and Excel/note 4+4+4+7+7/5 logic How would you ...
1
vote
0answers
174 views

Difference between RSQ function in Excel and Regression in the Excel Data Analysis Add-in?

When I use the RSQ function between one x variable and y variable, the resulting $R^2$ differs from the $R^2$ values given by running regression analysis from excel's Data Analysis. For example, ...
0
votes
0answers
60 views

Peak heavy data filter

I am trying to replicate the motion of a measurement needle with a set radius crossing over a rough surface in order to measure the surface texture. How can I create a filter to replicate this motion ...
1
vote
1answer
138 views

Visualizing the trend of monthly change in a times-series year-over-year

I am interested in a better way to plot monthly changes in a time-series. Especially I'd like to compare how the monthly change this year differs from the monthly change last year. Monthly change is ...
0
votes
0answers
8 views

One variable multiple treatments

I'm drawing a blank on how to analyze this data. I've got one drug/treatment type (variable) with multiple answer options (4 to be exact) and I'd like to compare the answer options for significance. ...
0
votes
0answers
10 views

Non-linear Variables in Excel [duplicate]

Regarding the following equation in excel regression: y = x + x^(-.5) + e I have made the equation nonlinear in the sense that I added to the data a new column which takes the values of x to the ...
1
vote
1answer
60 views

How to readibly visualize four related streams of network data?

I have network data coming from four different data streams simultaneously, and would like to visualize the data on some sort of concurrent timeline so I can identify potentially related events. I ...
0
votes
0answers
13 views

Interpreting results of Libreoffice Calc's TTEST function [duplicate]

I'm doing some data analysis on a small dataset (35 individuals) and I'm wondering whether my findings are statistically significant. Individuals are asked questions before and after a treatment, so ...
1
vote
0answers
23 views

Simple Path to Route Algorithm [closed]

I'm currently conducting research into subway paths, but stand in front of a problem, with no programming knowledge and an extremely short time-limit. Probably the question I am asking is trivial, ...
2
votes
0answers
45 views

Where does SKEW Excel equation come from?

I need to quote Excel's skew equation in a paper but I couldn't find any information about this equation: $n$: size of the population $s$: standard deviation signed $x$: mean Does anyone know ...
1
vote
1answer
44 views

Dummy Data & Regression Analysis

I've been doing some analysis projects at work and I've been supplied with some dummy data regarding whether an applicant has applied on a weekday or weekend (I have set this as 0 for weekend and 1 ...
0
votes
0answers
96 views

Determine if huge data sets come from the same distribution (R or Excel help)

I am doing a work assignment where I need to determine if three data sets come from the same distribution. After plotting the histogram they seem to be some rendition of a lognormal. I currently ...
0
votes
0answers
69 views

Checking Friedman-Nemenyi Tests in Practice

Newbie here, unfortunately I don't seem to find a way to upload a .xls file so I'll describe what I did: 1) I want to verify whether there's a statistical realationship between the rankings of 52 ...
0
votes
2answers
120 views

Regression multiple customers per month

I have a file with sales for one complete year. Multiple customers, month number and total sales (per customer): ...