Dataset to demonstrate Proposed Probabilistic Measure of Design Reuse
This file contains data collected from a furniture company with an analysis procedure to demonstrate the probabilistic measure of design reuse. Please read our paper “A Probabilistic Design Reuse Index for Engineering Designs” before understanding this dataset. The file contains a MS Excel file with three sheets.
The details of each sheet are given below:
Sheets 1: Furniture data – This sheet contains all the data collected for chairs type furniture. Each unique component part is represented by the category instance and component occurrences recorded with reference to a specific named product.
Sheet 2: Full Dataset Chi-square score – This sheet illustrates the calculation of a probabilistic measure of design reuse for the chair products. The sheet transposes the component occurrence given in sheet one with subsequent calculation of Chi-Square distribution score. Please refer Equation 6 in the above mentioned paper. The subsequent rows demonstrates the total summation of above calculated values for each component and calculation of Chi-square value. The formula used to calculate the score can be noticed in Formula bar for each cell.
Sheet 3: Group wise Chi-square score – This sheet illustrates the calculation of a probabilistic measure of design reuse for each component type. The procedure is same as illustrated in the above point.