Category: Excel

The file tax data contains information from federal tax returns filed in 2007 for all counties in the United States (3,142 counties in total). Create a PivotTable in Excel to answer the questions below. The PivotTable should have State Abbreviation as Row Labels. The Values in the PivotTable should be the sum of adjusted gross […]

uncategorised

Excel Question

September 13, 2024

need done in 30 mins and send me a excel We have $80,000 to invest over a four-month period. The investment options available are two-month government bonds with a 3% return, three-month government bills offering a 6.5% return, and bank deposits with a 1% return per month. We can invest multiple times into these options […]

uncategorised

Data Preparation

September 9, 2024

Data_Set: cust_prod_details.xlsxDownload cust_prod_details.xlsx Data_Source: Tableau course: Download practice datasets (2018, Dec 03). In SuperDataScience. Load the Amazon_Order_Data into the Tableau desktop & perform the following on respective data tables and save it. (2 points) Change the Order ID Column name to OID (Order_Breakdown). (2 points) Convert the datatype of profit from Number (whole) to Number […]

uncategorised

Consider Data on Sales Transactions and answer the following…

September 7, 2024

Consider Data on Sales Transactions and answer the following questions : 1- Give the right data type for each attribute. 2- Find a variable which could be visualized using a Pie chart and draw the pie chart using Excel. Interpret the chart. 3- Find a variable which could be visualized using a Culumn chart and […]

uncategorised

hsci 391 Excel

July 30, 2024

Please see attached an excel workbook to work form. See below the list of instructions on how to complete the workbook. Task Download the . This data contains counts of inpatient visits that lead to a discharge to a hospice care facility in 2022. The Start with the “Test Your Skills” worksheet Add a Fake […]

uncategorised

Retail company dashboard

July 13, 2024

Create a comprehensive information dashboard for a retail company using Excel. The dashboard should visualize the company’s sales data over the past year, including monthly sales figures, product category performance, and regional sales distribution. Your dashboard should include the following features: At least three different types of charts or graphs (e.g., line chart, bar chart, […]

uncategorised

Forecasting Using Causal Regression Model

June 14, 2024

Data in the Excel File shows the demand for one type of chip used in industrial equipment from a small manufacturer. Construct a combo chart of the data. What appears to happen when a new chip is introduced? Develop a causal regression model to forecast demand that includes both time and the introduction of a […]

uncategorised

Forecasting Using Moving Average and Exponential Smoothing

June 14, 2024

Use the data in the Excel file to do the following: Develop spreadsheet models for forecasting attendance using single moving average and single exponential smoothing. Using MAD, MSE, and MAPE as guidance, find the best number of moving average periods and best smoothing constant for exponential smoothing. Instructions: Write your answer in a Microsoft Excel […]