Excel Statistics 89: Hypothesis Testing With Critical Value & p-value

Hi Everyone - can any of you help me with this question in my assignment?
I'd be very grateful for any assistance!

. Write a function named PValue(cfs, per, r) that returns the present value of a set of cash flows contained in the range cfs (cfs can be either a row or a column.). The range per contains the periods in which each cash flow occurs (e.g. the first cash flow in cfs occurs in period 2, the second cash flow is in period 5). The discount rate is r per period. Do not use any Excel functions within PValue().

Happy new year to everyone!

I would like to know how I can test the hypothesis in excel, for example Tuesdays have lower volume than the average weekday?

Day Volume
Sun 2,650
Mon 2,581
Tue 2,337
Wed 2,972
Thu 3,166
Fri 3,189
Sat 2,408
Avg Day 2,753

Thanks in advance!

=IF(G8>=2000,S47,G8/2000*S47)+(((N6+R6)/2)*((IF(G26="RCG",0.05,0)+IF(G28="RCG",0.025,0)))+((V42*0.1)*(G8*1000)))

Assuming:

G8 = 4000
S47 = 2453
N6 = 39000
R6 = 85800
G26 = RCG
G28 = RCG
V42 = 0.62%

Answer should be = 9629

PLZ anybody solve it step by step.

Hi all, I work for a not for profit theatre and I'm trying to put together a calendar that shows the following:

- Show (as what the production name is)
- It's season start date
- A series of actions that need to be undertaken to ensure deadlines are met for marketing etc AND these actions need to occur in sequence working back from the show season start date.

For example, the mailout is to occur 4 weeks prior to the show start date, therefore the cell needs to calculate the date 4 weeks back from 'show start date' which is the ultimate / target date of course. There are a series of about 10 actions that need to occur and they all have set timeframes in place that work back from the show date.

The purpose of this spreadsheet is to have a resource that can be used on a weekly basis to show where things need to be for each show. I am using Excel 2003.

I appreciate any assistance on this, I for the life of me cannot work it out alone!!

Tim

Hi All,

I am really confused and toiled on a project which requires 2 major automizations, please help if you can I would really appriciate your help:

O/S used: Win 2000

1) I require a macro to send an excel sheet copied as a whole in an outlook message box and also attach one more excel sheet but as an attachment in the same mail, with specified subject line and specified distribution list from outlook.

2) I was also looking for a macro which would help me update an excel database with live udates from a database.

I would really and greatly appriciate your help.

Thank You for your consideration,

Performing hypothesis testing on data comprising of hours devoted to patient care per week for practitioners in conventional and alternative medical practices. I have used data analysis -> z-test-two sample for means to perform my calculations.

I would like to know if this is the correct way to perform the hypothesis calculation.

See attachment for more details.

I need to state a null hypothesis for the regression analysis I just performed in Microsoft Excel. The Significance F number is greater than 0.05, so that means that the null hypothesis is accepted. My instructor uses this format for the null hypothesis:

H0: y is not linearly dependent on x, and the slope of the line (y = bx + a), b = 0.

However, the equation for the regression line I came up with is y = 16.75x + 710.5.

So isn't b actually 16.75? If that is the case, then how do I state the null hypothesis?

I am unable to figure out how you can do hypothesis testing if you only know population mean, claim, and sample size. Can someone help me please?

Question:

Recall that “very satisfied” customers give the XYZ-Box video game system a rating that is at least 42. Suppose that the manufacturer of the XYZ-Box wishes the use the random sample of 65 satisfaction ratings to provide evidence supporting the claim that the mean composite satisfaction rating for the XYZ-Box exceeds 42.

Set up the null and alternative hypotheses needed if we wish to attempt to provide evidence supporting the claim that the mean exceeds 42.

I have a data set based on an uneven distribution of cards in a 60 card deck, each with a value ranging from 0-5.

I need to build a probability distribution of all the random samples of 10. So, how many random sets of 10. have an average value of 1 (or a total of 10) etc.

Then, I need to build a variable distribution so that it changes as I change the sample size. So, with a sample of 20 cards, what does the distribution look like?

Can this be done in excel? Should I post what I have now to work with?

Hi everyone, first thanks for the help.

I am trying to create a histogram and let me explain some of the data.

I have a list of data separated like so:
3.5
3.6
3.8
3.8
3.9
3.9
etc...

Now I need to calculate the frequencies of these like so:
3.5 (up to but not including) 4.0
4.0 (up to but not including) 4.5

I can count out the frequencies myself but i need to create a histogram (bar graph) with the y axis as the frequency and the x axis as the IMR(infant mortality rate: ie the 3.5 (up to but not including) 4.0).

I am having problems with calculating the frequencies because when setting the bin values because they include 4.0.

If this is confusing I can provide some more information, but cannot find a good tutorial that would create a histogram anywhere remotely close to the histogram i drew by hand.