DAN 315326 Data Analytics K Scheme Manual Answer
In this post, we shared a list of practicals under DAN 315326 Data Analytics K Scheme Manual with their answer information.
All the latest practicals of this manual according to the new MSBTE teaching scheme are given below. This subject deals with Statistical Analysis in Excel.
DAN 315326 Data Analytics K Scheme Manual Answer
| Sr. No | Practical Title |
| 1 | *a. Calculate mean, median, and mode for a given dataset using Excel functions(AVERAGE, MEDIAN, MODE). *b. Calculate range, interquartile range IQR),variance, and standard deviation using Excel functions (STDEV, VAR). *c. Calculate the correlation coefficient between two variables using the CORREL function |
| 2 | *a. Construct a box plot using the Insert Chart feature to identify the median, quartiles, and outliers of a dataset. *b. Perform a simple linear regression analysis *c. Conduct a t-test to compare means between two groups *d. Calculate confidence intervals *e. Conduct a Chi-square test |
| 3 | *Create a Data Table a. Import a sample dataset (e.g., sales data) into Excel. b. converts the dataset into an Excel Table using the "Format as Table" feature and apply appropriate styles. C. Create a dashboard sheet that summarizes key metrics (e.g., total sales, average sales per region) using tables. *Data Cleaning a. Identify and remove duplicates from a dataset. |
| b. Use functions like TRIM, UPPER, LOWER, and PROPER to clean text data. c. Find and replace values using the Find & Replace feature. | |
| 4 | Create a Pivot Table a. A basic pivot table from a dataset b. Specify and filter data in a pivot table c. Add a calculated field to a pivot table d. Group data within a pivot table. Refresh pivot table data after making changes to the source data. Filter and sort a PivotTable a. Apply a Filter to the PivotTable b. Sort Data in the Pivot Table. c. Add slicers to the PivotTable for interactive filtering. |
| 5 | Create a Pivot Chart a. A basic pivot chart from a dataset b. A dynamic pivot chart that updates based on user selection c. Group date items in a pivot table to summarize data by month or year d. Group product categories in a pivot table |
| 6 | *Create a Simple Chart a. A simple bar chart to visualize data sets b. A chart using non-adjacent cells to visualize data from different ranges. *Create a Chart Using the Chart Wizard a Select the chart you created and experiment with the |
| Chart Tools options b. Modifying Charts c. Moving an Embedded Chart d. Sizing an Embedded Chart | ||
| 7 | *Change the Chart Type a. Create a basic bar chart using a dataset and change its type to a different chart b. Experiment with different data display options, such as adding data labels, changing the axis format, and adjusting the gridlines c. Experiment with position and style of the legend | |
| 8 | a. Create a pie chart from a dataset b. Move the pie chart to a new worksheet for better visibility c. Emphasize a specific category by exploding a slice of the pie chart d. Customize the appearance of the pie chart for better presentation | |
| 9 | * Create different types of plots. Write a Python script to save the plot in different formats: PNG, PDF, and SVG. | |
| 10 | Application of data analytics across various industries through case study | |
Conclusion
Write all practicals as per the list given above and also complete practical work such as microproject and assignments fast to get more time for exam preparations.