Scrape and store data for html display
Beautifulsoup is an HTML parser. You can feed it an HTML page using Python, and extract the data you need from it. Then you can post-process the data in Python, and load it into MySQL once you're ready. I'm a bit confused about the step MySQL -> HTML, since neither is a programming language (HTML is a markup language that can't talk to MySQL, and MySQL is a database management system that can't directly output HTML), but sure, displaying MySQL data in an HTML page is a trivial step.
It might be a good idea to separate these steps a bit better, by the way. You have some code that extracts data and loads it into a database, and you have some code that displays data from the database. Keeping these two separated might increase you code quality.
I have coded python to scrape a webpage and retrieve listing prices.
I want to store the data and conduct a statistical analysis on the dataset. 
Would this work?
Python -> beautifulsoup -> mySQL -> html
Data set:
$10 , $20, $10
I want to be able to calculate averages and then display them on the html page.