“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Hypothesis testing that returns of a company are greater than returns to the market using Data Analysis: t-test: 2 small assuming unequal variances what mean difference should I define?

Solved by S. H. in 25 mins

an excel fomula that returns of a company are greater than returns to the market using Data Analysis: t-test: 2 small assuming unequal variances what mean difference should I def

Solved by B. Q. in 24 mins

hello.all I need to do is a an excel Hypothesis testing that returns of a company are greater than returns to the market using Data Analysis: t-test: 2 small assuming unequal variances

Solved by Z. Y. in 12 mins

Design a workbook named sales_LastNameFirstName to help you track your weekly sales commission.
Your name should list in cell A1 in an enlarged font size with a different color than the default color merged and centered across all columns used.
Display in a labeled cell your weekly base pay as a salesperson.
Display in a labeled cell the amount of commission earned the previous week.
Your company pays commission based upon the number of sales made in the week. The commission rate is then multiplied by the weekly base pay to compute commission amount. An English description is given below of commission rates. Use that data to create a lookup table placed on the workbook. Add a box border around the lookup table.
Number of Sales Commission Rate
1-9 3.0%
10-19 3.5%
20 or more 3.8%
Include column headings for date, number of sales, commission rate, commission amount, and total pay.
Format the column headings row with some border in a different color than the default color and each entry boldfaced and center-aligned in its cell.
Include five rows of data for the five business days Monday - Friday. For the first row, enter a particular Monday date and for remaining rows, add 1 to the previous date to compute the new date.
Use the VLOOKUP function to compute the commission rate for each day based on the number of sales.
Compute the commission amount from the commission rate and the base weekly pay.
Compute the total pay as the sum of base pay and commission amount.
Under the rows add a labeled cell and display the sum of commission amounts.
Use the IF function that compares commission amount earned this week to the previous week's value and reports some congratulatory message if the current amount exceeds the previous amount, and some other message otherwise. Format the message in boldface in the same font color as your name.
Use Currency format with two decimals on all money amounts.
Use Percentage format with one decimal on all percentage values.
Insert a small money-related image to the right side of the row data to fit the size of the five rows.
Rename Sheet1 appropriately and delete unused sheets.
Add a header of your name in the left side, sheet name in the middle, and current date on the right side.
Your workbook must be unique and reflect your own data and design.

Solved by S. J. in 12 mins

I would like to create a very small spreadsheet that would continuously add a number I type in one cell (say A1) and keep an ongoing total in another cell.

Solved by E. E. in 18 mins

I'm having problems with creating 3 small pivot tables.

Solved by T. J. in 30 mins

mouse pointer arrow has suddenly become a small white cross

Solved by D. H. in 25 mins

I am trying to make a birthday calendar to pull data from rows in a table and put the results in columns. I am using this formula: {=INDEX($A$2:$D$7,SMALL(IF($A$2:$A$7=$B$12,ROW($A$2:$A$7)),ROW(1:1))-1,4)}
The table has "Month" (so there are repeats), "First Name", "Age" (calculated for each year), and "Day" (of the month the birthday is on).
I want the columns to match the month (entered in a cell above the columns) and put the correct information in Day, First, and Age columns. This works for the first 2 columns but when I try to change the formula in the 3rd column to capture the age it reverts to the formula in the 2nd column and captures "First" again.

Solved by X. H. in 30 mins

I am 95% there in creating the following "Payroll Stub report" from our employee payroll database. I am able to return all dates for the pay period base on a period start date and end date. Then return the rates and hours worked on any of the days in the period. However, if an employee works two jobs in the same day it will return only the first job. I am thinking somehow to combine Index Match with the excel small function. Help

Solved by A. B. in 21 mins

Hi, I have a growth rate model based with a scale from small, medium, large, extra large, plus this is over a 12 month period. I have several companies to predict the number of enrolled users based on this data but where I am stuck is that when I move the launch date of the company how to I get the growth assumptions to know to reference the first month in the growth model but also within the correct moth of launch.
for example;
M1 M2 M3 M4 M5
Small 12% 25% 37% 49% 61%
Medium 8% 17% 24% 39% 50%
Large
Extra Large
Jan Feb Mar Apr May Jun etc...
Company A
Company b
Company c
Company d
Now if say Company A decides to launch in May, how do I get the formula to know to look at the %'s in the the column for M1 and put the figures starting from May onward?

Solved by V. L. in 29 mins