Get instant live Excel expert help to learn how to use Small function in Excel

I need to create a pivot table to know how many small business ship by regular air (shipping method).

I work for a small trucking company and we use an excel spreadsheet that is shared between myself and the owners. We have been using SHARED spreadsheet for months with no problem and now when i update it weekly they can no longer see what I'm doing and I cant figure out how to add them again...Please help me..

I can't print on Mac of an excel worksheet. I set the limits and it just wants to print really small or white pages.

I have Excel on a Mac and I can no longer pull up the menus when I click on the small down arrows on my toolbar. If I try to pull up the different colors Fill Colors nothing happens. Same thing with the font colors pull down. Any ideas?

need excel spread sheet created. No calculations needed. 9 different small group spreadsheets for cost assessment.

The accompanying dataset contains six years of quarterly sales from your store. You would like to forecast future sales as way to inform you as you make staffing and budgeting plans. Please answer all of the following questions. The dataset can be found here. For numerical questions, answer with 4 digits to the right of the decimal. Statistically test at the alpha=0.05 statistical significance level whether or not there exists a linear trend in the time series data. What is the p-value of your statistical test? Based on your answer to the question above, can you conclude that a linear trend exists in this time series data (Y or N)? ===== Regardless of you answer above, create a multiple linear regression model that captures both linear trend and additive seasonality. You should use Q4 as your base season and fit the model with all 24 data points. All of the independent variables are statistically significant at the alpha=0.01 level (Y or N). Which quarter (1, 2, 3, or 4) has the largest sales on average? Which quarter (1, 2, 3, or 4) has the smallest sales on average? What is the value of the Adjusted R-squared? Using this multiple linear regression model, what is the value of the MAPE? (Please report it as a percentage with 4 digits to the right of the decimal and no percentage sign.) Using this multiple linear regression model, forecast each quarter for the next year (2016). What is the forecast for Q3? Carefully explain the how to interpret the value of the estimated coefficient on the time period index. Carefully explain the how to interpret the value of the estimated coefficient on the variable representing quarter one. ===== Using the same dataset as before, you now would like to add an exogenous variable as a possible explanatory variable to the model. This variable is in the column labeled ‘Ads – Lag 1’. This variable represents the number of advertising campaigns ran the previous quarter. (The thought is that the ads run last quarter affect the current quarter’s sales.) Calculate the correlation coefficient between the variables ‘Ads – Lag 1’ and ‘Sales’. What is its value? Continuing with this thought, now create a multiple linear regression model that captures both linear trend and additive seasonality. You should use Q4 as your base season and fit the model with all 24 data points. Additionally, add the variable ‘Ads – Lag 1` as an independent variable. Is the variable ‘Ads – Lag 1` statistically significant at the alpha=0.05 level (Y or N)? What is the value of the Adjusted R-squared value? 0.4699 Using this multiple linear regression model that captures trend and additive seasonality and the additional independent variable for advertising, what is the value of the MAPE? (Please report it as a percentage with 4 digits to the right of the decimal and no percentage sign.) Using only the data that you have been given, can you make forecasts for the year 2016 using this model (Y or N)? If your answer was “Y” above, then what is the forecast for Q1 of 2016. If it was “N”, explain why not.

Question 6: Create a multitab UserForm which has 2 tabs. Under a tab named Statistics and using the data found on the Stats.xlsx worksheet, allow the user to select the data, and then display in a MsgBox these statistics: The average of the selected data The standard deviation of the selected data The largest value in the selected data The smallest value in the selected data The median of the selected data Also need run button.

Hello The following is my file in which i need to use a database function to find out the smallest, largest and average sales in the central region.

I want to sort a list of numbers into smallest to largest while retaining the numbers original list number value

Freeze the first row on the Fleet Information worksheet. Convert the data to a table, name the table Inventory, and apply the Table Style Medium 19. Remove duplicate records. Sort the table by Make in alphabetical order, add a second level to sort by Year Smallest to Largest, and a third level to sort by Sticker Price Smallest to Largest. Repeat the field names on all pages. Change page breaks so each vehicle make is printed on a separate page. Add a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side. Click the Sales Information worksheet and convert the data to a table, name the table Sales, and apply the Table Style Dark 11. Type % of sticker in cell E1. Create a formula with structured references to calculate the percentage of the Sticker Price in column E. Format the range E2:E30 with Percent Style Number Format. Add a total row to display the Average of % of sticker and Sum of Sticker Price and Sale Price. AutoFit the width of columns B:E to show the total values. Apply Solid Fill Blue Data Bars conditional formatting to the % of sticker data. Select the range E2:E30 and create a new conditional formatting rule that uses a formula to apply yellow fill and bold font to values that sold for less than or equal to 70% of the sale price. On the First Quarter Sales worksheet, rename the table FirstQuarter. Filter the data to display January, February, and March sales. Add a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side. Select Landscape orientation for all sheets.