DAN 315326 Data Analytics Manual Answer

In this blog post, we shared DAN 315326 Data Analytics Manual Answers. This Laboratory Manual for Data Analytics (315326) is for fifth-semester computer diploma engineering students under the Maharashtra State Board of Technical Education (MSBTE) ‘K’ Scheme Curriculum.

Our team members have solved all important practical exercises in this manual to help students complete their practical work.

DAN 315326 Data Analytics Manual Answer

• Practical No. 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.

• Practical No. 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

• Practical No. 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.

• Practical No. 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.

• Practical No. 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

• Practical No. 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

• Practical No. 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.

• Practical No. 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

• Practical No. 9 Create different types of plots. Write a Python script to save the plot in different formats: PNG, PDF, and SVG.

• Practical No. 10 Application of data analytics across various industries through case study.

Conclusion

In this post we shared Data Analytics subject lab manual solutions for engineering diploma students currently studying in fifth semester.

Computer 5th Semester All manual answer