month
1
2
3
4
5
6
7
8
9
10
11
12
# of units
15000
16000
17000
18000
17000
18000
35000
50000
15000
16000
17000
18000
I need to project sales based on 2 year's of history data. I know that sales in months 7 and 8 had promotion activity and should be neutralized in projecting trend and seasonality. Anyone have a good Excel model, function/formula or add-in product for consumer goods Sales forecasting. Also less expensive than J Galt's or Forecast Pro's product which I believe are addin products for Excel?
Thanks,
SW
I have the following problem for my stats class and I am trying to figure out which statistical formual I need to use to get the answer. Please advice! Any help will be much appreciated.
A sample of salaries finds sample mean $35 thousand and sample variance 81. If the population mean is to be estimated within $2 thousand (that is, $2 thousand above and $2 thousand below), how many employee salaries must be sampled? Assume 95% confidence and t-multiple = 2.
Ladies and Gentlemen,
I've never done this before but I need to find the standard deviation, mean, and slope of the last 5 points of a flat array. Code example is as follows:
Code:
Dim DataArray as Variant
Dim Std, Mean, Slp
DataArray = Application.Range("Data")
Std = application.Stdev(DataArray) or something likethis
There must be an easy way to do this. Any help appreciated
Hello;
1) I need to calculate M43:: sum[m=1 to m=9] G(m)*sin(m*x) for each value of tabulated x in column L.
The 9 values of "m" are tabulated in $D$21:$D$29
The 9 values of G(m) are tabulated in $C$21:$C$29
The first x value is in cell L43
Can someone please help in deriving the array formula to be entered in M43 ??
For other values of x in L44, L45, ... one would simply copy M43 and paste in M44, M45, ...
2) If it's not too much trouble, how about:
N43:: -sum[m=1 to m=9] G(m)*cos(m*x)/m for each value of tabulated x
Your help would be greatly appreciated.
Regards.
How to create a number series within an array formula, I mean, the series starts with 1 and will finish with 8 for example;
{1;2;3;4;5;6;7;8} - It will be the result within my array formula.
In Aij matrix means i=1 to 8 {i+1;i+1;i+1;i+1;i+1;i+1;i+1;i+1}.
I need to retrieve it within an array formula.
How can I do that just using an array formula.
Luthius
I have a list like this:
Sheet1
A
B
C
1
Alfa
Status D
75
2
Bravo
Status A
3
Charlie
Status B
483
4
Delta
Status B
78
5
Echo
Status C
6
Foxtrot
Status A
7
Golf
Status B
8
Hotel
Status B
12
9
India
Status A
10
Juliett
Status A
405
11
Kilo
Status C
12
Lima
Status B
13
Mike
Status A
14
November
Status B
27
15
Oscar
Status B
13
16
Papa
Status B
17
Quebec
Status C
140
18
Romeo
Status B
426
19
Sierra
Status C
484
20
Tango
Status D
197
Excel tables to the web >> Excel Jeanie HTML 4
I want to single out all Status B values, and put them in a new table in descending order.
In this case, it would look like this:
Sheet1
A
B
C
10
Charlie
Status B
483
11
Romeo
Status B
426
12
Delta
Status B
78
13
November
Status B
27
14
Oscar
Status B
13
15
Hotel
Status B
12
Excel tables to the web >> Excel Jeanie HTML 4
So I need to ignore blank values, determine which row has the highest quantity, and then return the value in column A and column C.
I know I can use array formulas to a certain extent, but I'm stumped as to how to store the row of the highest values in the array while ignoring blanks. Any ideas?
Hello
How do you write the following formula in VBA?
PHP Code:
=RADQ(A3^2+B3^2)
Hello all,
I have a spreadsheet of co-ordinates (Eastings & Northings). Columns A & B contain the co-ordinates of school premises. Columns E & F contain the co-ordinates of anti-social behaviour incidents. In column C I'd like to show a count of anti-social behaviour incidents occuring with 100m of the school (Easting & Northings are in metres which is handy)
Easting Northing Results Easting Northing
502871 107008 ------------- 518902 116729
585461 136574 ------------- 531108 108205
487650 135334 -------------
In my actual data I have about 464 anti-social behaviour incidents and 697 schools
I've worked out how to calculate the distance between school and incident using a pythagoras formula like this...
=SQRT((ABS(A2-D2))^2+(ABS(B2-E2))^2)
...but that isn't really what I need. What I really need is a count are incidents where the answer to this formula is >100m
Please help? I've tried everything I can think of.
