About 26,200 results
Open links in new tab
  1. How do you put values over a simple bar chart in Excel?

    I'd like to put values over a simple bar/column chart in excel. A similar question was asked for R, and I know how to get my data into R, but not how to make the charts.

  2. regression - My p-values increase when adding variables: is the …

    This is where I am getting confused, as I add another variable the R2 (and adjusted R2) increase but the p values both increase above .05 (but independently are less that .05). What does this …

  3. Making horizontal max-min-average chart in Excel [closed]

    I'm trying to make a min, max, average chart with horizontal lines, where the vertical axis represents years in the series, something similar to this chart at I've already created the data …

  4. excel - How to apply a logarithmic trendline if X Values = 0?

    How to apply a logarithmic trendline if X Values = 0? Ask Question Asked 11 years, 10 months ago Modified 11 years, 10 months ago

  5. Calculating p-values for the 1-Sample Kolmogorov Smirnov Test …

    I have coded the algorithm for computing the p-value for the 1-Sample Kolmogorov Smirnov Test for Normality in EXCEL VBA published by Marsaglia et al. During recent tests prior to release …

  6. time series - Performance of Holt-Winter´s seasonal method is …

    Jul 1, 2021 · Excel Documentation: Microsoft: Calculates or predicts a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) …

  7. Get Standard Deviation and Variance of log 10 data in Excel

    Mar 17, 2022 · In Excel, my data is between 0.000001 and 0.005 and treated as "logarithmic" so I transformed by log 10 (log10 (x)) which are all negative. The Excel Var.P () and Stdev.p () …

  8. time series - Forecasting beyond one season using Holt-Winters ...

    The monthly data has an increasing trend and annual seasonality. I'm using MS Excel with the Solver add-in to calculate the optimal values of $\alpha$, $\beta$ and $\gamma$ to give the …

  9. How to add periodic component to linear regression model?

    The peaks will be your major frequency components that you want to model. When you add these cyclic predictors, pay close attention to their p-values in your regression, and don't overfit. Use …

  10. How to stop excel from changing a range when you drag a …

    I'm trying to normalize a set of columns of data in an excel spreadsheet. I need to get the values so that the highest value in a column is = 1 and lowest is = to 0, so I've come up with the formu...