Get instant live Excel expert help with AVERAGE Function

i want to 2 types of data in length but the data was taken at different lengths and different intervals. 1 type only has 300 data points the other over 900. I want to be able to average the data with 900 points within the intervals for the data with only 300 points. that way they can be compared

I have a spreadsheet where a 'non-response' is auto added as a -99 figure, while all other numbers are between 1-7. Given there may be a number of these in any given row/column which I need to discount from my average, and I need to know exactly how many in each line, is the a formula I can put at the end which identifies the number of responses '-99'?

I am using formulas in my excel to calculate the average, but i want the percentage to be rounded up

How’s it going? Here I have a table (let’s call it Table 1) that would ordinarily be populated, but I cannot share the values unfortunately. To the far right you can see another little table I used to find the average values for each category and year using AVERAGEIF and also basic formulas for year on year changes (let’s call it Table 2). On Sheet2 is the transposed version of that table (Table 3), which is the one I want to populate using a formula linking it to Table 1 (eliminating the need for Table 2). I think the formula to use might be HLOOKUP, but I could be wrong… maybe HLOOKUP and AVERAGEIF. I would really appreciate your help on this. Thanks!

These 3 questions need to be answered please. I can provide the data set when necessary. Question 1: 1.) During a TYPICAL MONTH of school, how often do you skip class? 1: Never 2: Rarely 3: Sometimes 4: Often 5: Almost Always i. Construct a histogram of the numerical responses for each of the first, second, third and fourth years. For each histogram, identify which response is the most frequent and identify and differences or similarities you observe. ii. Perform at the 5% significance level the one-way ANOVA test to compare the population means for each of the 4 years of data. Should we reject or not reject the claim that there is no difference in population means between each year? Question 2: Is there a linear relationship between frequency of skipped classes and grade average? Consider the data in columns C-F which provide grade average in years 1-4 respectively and the data on how often classes are skipped that you worked with in Questions 1 and 2. a) Use Excel to find the correlation coefficient for average and classes skipped for each of the four years. b) Identify the year that has the strongest linear relationship. Using the data for this year, use Excel to obtain a full regression analysis including a scatter plot with regression line plotted, regression line equation, coefficient of determination. (Hint: Use classes skipped as the explanatory variable.) c) Based on the correlation coefficient and the analysis in b), do you feel that frequency of classes skipped is a good predictor of grade average for this year? Explain by making reference to relevant numerical measures where appropriate. Question 3: We will now look at whether or not a relationship exists between grade average in third and fourth year. a) Use Excel to find the correlation coefficient for this data. b) Use Excel to obtain a full regression analysis as in #2 b) above. (Hint: Use average in third year as explanatory variable.) c) Test the claim that there is a positive linear correlation between the two sets of grades at a 0.01 level of siginficance

I have data that is all patient appointments on a medical floor. I want to create a pivot table that gives me the average # of patients that come in on Monday mornings, Monday afternoons, Tuesday mornings, etc.

Add Minimum Cost and Maximum Cost rows that are formatted similarly to row 50 (Average Cost row). Use functions to calculate the minimum and maximum costs for the systems purchased. Convert the Initial Cost data including the Average Cost, Minimum Cost, and Maximum Cost, and the Depreciated Value data from a generic number to accounting format with no decimal places. Copy the average, minimum, and maximum functions to the Depreciated Value columns. Merge and center the title “Desktop & Laptop Systems Inventory & Depreciation” above all of the columns with data. The CEO has asked you use conditional formatting to create an easy visual on the spreadsheet of any device that is near the end of its useful life. Utilize conditional formatting for all columns that contain a depreciated value of less than $500 they will appear red. Create a pie chart to show the initial cost totals by department. You may create a set of summary data to the right of the current data to use for the creation of your chart.

You are going to roll four twenty-sided dice. If the rolls total to 20 or less, roll two more twenty-sided dice and add that to the total. For instance, if the total of my four die rolls is 32, then that is the score of the game. If the total is 17, then I roll two more dice and add that to the total. If these two bonus dice total 20, then the score of that game is 37. Of ten thousand games, what is the average score? (choose the closest range)

Calculate the total and average sales for each sales representative.

I have 3 columns. 1 says total daily lines, 2nd says total hours worked and 3rd says total errors. I am trying to find a formula that gives me the of average of total lines per hour per day.