Week 13: Excel Escapades

Graphs from my comparative study depicting the presence of concentric rings in quilt patterns and overall patterns over time.

For the comparative analysis, I used Microsoft Excel to organize data and SPSS to process data. A simple dataset of appurtenant information was entered into Excel, then exported to SPSS, which I used to add an additional field of sorting by decade. This is a royal pain in Excel, and one of the main reasons I switched to a different processing software. SPSS is also very useful for running frequencies and cross tabulating information. I created graphs depicting change over time of patterns, materials, forms, and sizes. I also made a graph of which quilts had concentric patterns over time. As mentioned previously, no significant patterns were found in these areas, which may be due to the small sample size of 30 quilts.

For the “mean fabric dating,” I entered each of the estimated date ranges for 11 of the 12 fabrics into Excel and used Stanley South’s method for finding a weighted average as we learned in our archaeology class. I also ran an unweighted average, to determine whether large volumes of a particular fabric were significantly pulling my date one way or the other. I also created a graph showing a count of fabric pieces and what decades each dated to, illustrating what decades most of the fabric was from.




Historic Preservation, Class of 2022

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Getting Started with Neo4j and Gephi Tool

Exploring Recruitment Bias using Machine Learning and R

Combined flooding impact from hurricanes Iota and Eta using SAR analysis

XGBoost vs LightGBM on a High Dimensional Dataset

Understanding the Central Limit Theorem, Standard Error and Confidence Intervals

Visualize High-Dimensional Network Data with 3D 360-Degree-Animated Scatter Plot

Tableau’s AI-enabled Explain Data feature

What I have learned from building a pharmacogenomics platform using data analytics tools

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Kelly Pedigo

Kelly Pedigo

Historic Preservation, Class of 2022

More from Medium

Top 4 Tips To Land A Job After Doing A C++ Course

Top 10 Best Hopin Alternatives: Reviews

FILM REVIEW: “The King’s Daughter”